Displaying Workbooks on the Taskbar

Summary: By default Excel displays each open workbook as a separate task on the Taskbar. If you prefer, you can configure Excel so that there is only a single task button representing all open workbooks.

You can control how Excel workbooks appear on your task bar. You can instruct Excel to display only a single task regardless of how many workbooks are open, or you can have it display one task for each workbook.

To specify how Excel utilizes the toolbar, follow these steps:

Click the Office button, then click Excel Options. Excel displays the Excel Options dialog box.
At the left side of the dialog box, click Advanced. (Click here to see a related figure.)
Scroll through the available options until you find the Display group.
Set the Show All Windows in the Taskbar check box, as desired.
Click on OK.

Related Tips:

Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books. Check out WordTips Premium today!