You may have many Excel files open, but each one creates a separate icon on your Windows taskbar. This makes it hard to find the correct file and wastes screen space. Excel has a built-in setting to group all open workbooks under one application window. This article shows you how to enable this setting and manage your files efficiently.
Key Takeaways: Group Excel Windows
- File > Options > Advanced > Show all windows in the Taskbar: Unchecking this option merges all Excel workbook windows into a single taskbar button.
- View > Switch Windows: This menu lists all open workbooks for quick navigation when they are grouped under one window.
- Ctrl + Tab: This keyboard shortcut cycles through all open workbooks within the single Excel application window.
How Excel Handles Multiple Windows
By default, Excel opens each workbook in its own application instance on Windows 10 and Windows 11. The operating system then shows a separate taskbar button for each instance. This is called Single Document Interface mode. It can be useful if you want to move workbooks to different monitors independently.
The alternative is Multiple Document Interface mode. In this mode, one main Excel window contains all your open workbooks. Only that main window appears on the taskbar. You switch between files using Excel’s own menus or keyboard shortcuts. This mode is ideal for keeping your taskbar clean when working with many related files.
Prerequisites for Changing the Setting
You need a version of Excel that supports this option. It is available in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016. The setting applies to the Excel application itself, not to individual files. Changing it will affect all workbooks you open from that point on. You do not need administrator rights to change this user-specific option.
Steps to Enable Single Taskbar Button for Excel
Follow these steps to group all Excel workbooks under one taskbar icon. The change takes effect immediately for new workbooks you open.
- Open Excel Options
Launch Excel and open any workbook. Click the File tab in the top-left corner. Select Options from the bottom of the left-hand menu. This opens the Excel Options dialog box. - Navigate to Advanced Settings
In the Excel Options dialog, click Advanced in the left sidebar. Scroll down through the long list of settings. Find the section labeled Display. - Change the Taskbar Setting
Look for the checkbox labeled Show all windows in the Taskbar. By default, this box is checked. Click the checkbox to uncheck it. Click the OK button at the bottom of the dialog to save the change. - Test the New Setting
Close and restart Excel completely. Open two or three different workbooks. Look at your Windows taskbar. You should now see only one Excel icon, regardless of how many files are open.
Navigating Between Grouped Workbooks
With multiple workbooks in one window, you need to know how to switch between them. Use the View tab on the Excel ribbon. In the Window group, click the Switch Windows button. A dropdown list shows all open workbooks. Click any name to bring that file to the front.
- Use the Keyboard Shortcut
Press and hold the Ctrl key. Tap the Tab key to cycle forward through your open workbooks. A small thumbnail preview appears. Release both keys to switch to the highlighted workbook. Add the Shift key to cycle backwards. - Use the Taskbar Preview
Hover your mouse over the single Excel icon on the taskbar. A thumbnail preview of all open workbooks will appear. Click on the thumbnail of the workbook you want to activate.
Common Mistakes and Limitations
Setting Does Not Apply to Already Open Files
If you change the setting while workbooks are open, those specific windows may not regroup immediately. The new behavior fully applies after you close Excel and restart it. Always restart the application to ensure the setting is active for all new sessions.
Excel Still Shows Multiple Icons on Taskbar
If you still see multiple Excel icons, you may have multiple instances of Excel running. Check if you launched Excel from different shortcuts or file locations. Close all Excel windows from the taskbar. Then open Excel fresh from one shortcut and open your files from within that single window.
Cannot Move Workbooks to Separate Monitors Easily
Grouping workbooks into one main window limits how you arrange them across multiple screens. You cannot drag a workbook completely outside the main Excel window frame. To work on two monitors, you must use the View > New Window command to create a second view of the same workbook, then arrange those views.
Single vs. Multiple Taskbar Buttons: Key Differences
| Item | Single Taskbar Button (MDI Mode) | Multiple Taskbar Buttons (SDI Mode) |
|---|---|---|
| Taskbar Clutter | Minimal, one icon for Excel | High, one icon per workbook |
| Window Management | Switch via View > Switch Windows or Ctrl+Tab | Switch directly via Windows taskbar |
| Multi-Monitor Work | Limited, workbooks stay in main window | Flexible, each workbook can be moved independently |
| Excel Version Support | Available in all modern versions | Default behavior in Windows 10/11 |
| Best For | Working with many related files in one session | Working with unrelated files on separate screens |
You can now keep your Windows taskbar clean by grouping all Excel workbooks. Use the Switch Windows menu or Ctrl + Tab to move between your files quickly. For advanced multi-monitor setups, remember the View > New Window command to create independent views of the same data.