How to Ungroup Excel Windows on the Windows 11 Taskbar

How-to basics · Updated November 20, 2026

To show separate buttons for open Excel workbooks, change Windows 11’s taskbar setting to Never: open Settings > Personalization > Taskbar > Taskbar behaviors, then set Combine taskbar buttons and hide labels to Never. This Windows setting affects other apps as well as Excel. The steps below also cover Windows 10 and explain what to check if your workbooks still do not appear separately.

What You’ll Need

  • A Windows 11 or Windows 10 computer with Excel installed and access to its taskbar settings. You may need permission to change settings if the computer is managed by an organization.
  • At least two Excel workbook windows open if you want to see separate Excel buttons immediately. Save your work before closing or reopening workbooks while troubleshooting.
  • The steps are for the desktop version of Excel for Microsoft 365 on Windows. Excel for Mac has no Windows taskbar; Excel for the web appears within your browser, so its taskbar button represents the browser rather than an individual workbook.

Step-by-Step

  1. Check that you have more than one workbook window open. Open Excel workbooks you want to switch between. In Excel, select View > Switch Windows to see the open workbook windows listed. If the list contains only one workbook, there is only one Excel window to give its own taskbar button. If there are multiple workbooks in the list, continue to the Windows setting.
  2. Open Windows Settings. Press Windows key + I, or open the Start menu and select Settings. This is a Windows taskbar preference, not an Excel ribbon setting, so changing Excel’s view or display options will not ungroup its taskbar buttons.
  3. Go to the taskbar settings in Windows 11. Select Personalization in Settings, then select Taskbar. Scroll down and expand Taskbar behaviors. Find the dropdown labeled Combine taskbar buttons and hide labels. Depending on your Windows 11 release, the label or layout may vary slightly, but the combine-buttons control is within Taskbar behaviors.
  4. Choose Never. Open the combine-buttons dropdown and select Never. Windows should then display a separate taskbar button for each open window instead of combining windows from the same app into one button. The buttons may show workbook names if there is enough room; if space is limited, they may appear as separate Excel icons without full labels.
  5. Check the setting for additional monitors, if applicable. If you use more than one display and want separate buttons on every taskbar, look for the option to combine buttons on other taskbars and set that to Never too. Windows can apply taskbar behavior differently on the primary display and additional monitors, depending on the options available in your version.
  6. For Windows 10, use its taskbar control instead. Open Settings > Personalization > Taskbar. Find Combine taskbar buttons, open the dropdown, and choose Never. Windows 10 may label the options Always, hide labels, When taskbar is full, and Never. Choose Never to keep windows separate even when the taskbar has room. Windows 10 does not use the same Taskbar behaviors section as Windows 11.
  7. Confirm the result in the taskbar. Return to the desktop and look for a separate button for each open Excel window. Select each button to make sure it brings the expected workbook to the front. If you still see one Excel button, hover over it or select it: Windows may show previews of several windows even when the buttons are combined. Continue with Troubleshooting if you cannot get separate buttons.

The setting applies to taskbar windows generally, not only to Excel. With Never selected, open windows from other programs can also occupy more taskbar space. If you prefer grouping most apps, Windows does not normally provide a built-in option to ungroup Excel alone while leaving every other app combined. You can still use Excel’s window list or taskbar previews as alternatives.

Common Mistakes

  • Looking for an ungroup command in Excel. Excel does not control whether Windows combines its taskbar buttons. Use Windows Settings, as described above, rather than searching the View tab or Excel Options for a taskbar setting.
  • Changing the option to When taskbar is full. This does not guarantee separate buttons. Windows combines windows when it decides the taskbar is full, so the behavior can change as you open more apps or resize the taskbar. Choose Never if you want windows to remain separate consistently.
  • Confusing grouped taskbar buttons with grouped worksheets. If worksheet tabs at the bottom of a workbook are selected together, that is an Excel sheet-grouping state. Right-click one of the selected sheet tabs and choose Ungroup Sheets. This is different from ungrouping Excel windows on the Windows taskbar.
  • Expecting one button per worksheet. The taskbar shows application windows, not individual sheets or every file displayed inside a window. A workbook containing many sheets still counts as one Excel window.
  • Assuming the setting affects only Excel. Never changes how Windows combines other app windows too. If you switch back to Always, Excel and other apps can be grouped again.

Tips

  • Use descriptive workbook names. When Windows has room to show labels, meaningful filenames make separate buttons easier to identify. Save a copy or use File > Save As before renaming a file if you need to preserve its original name or location.
  • Use Excel’s window list when the taskbar is crowded. In Excel, select View > Switch Windows and choose a workbook from the list. This is useful if you decide to keep taskbar buttons combined or if several buttons are hard to distinguish.
  • Consider the space trade-off. Separate buttons can make switching direct, but they use more of the taskbar. On a small screen, or when many apps and workbooks are open, labels may be shortened or buttons may take up most of the available space.
  • Use the setting that matches your preference. Never keeps windows separate; Always keeps same-app windows combined; When taskbar is full switches between the two based on available space. You can return to Taskbar settings at any time and change the dropdown.

Troubleshooting

The dropdown is missing or the path looks different. First check your Windows version: Windows 11 has Taskbar behaviors under Settings > Personalization > Taskbar, while Windows 10 places Combine taskbar buttons directly on the Taskbar settings page. If the computer is managed by work or school, an administrator may control or hide some settings. In that case, ask the administrator whether taskbar behavior is restricted.

There is still only one Excel button. Verify that Never is selected, then check whether there are actually multiple workbook windows. In Excel, open View > Switch Windows. If only one workbook appears, open another workbook in its own window. If several workbooks are listed but Windows still shows one button, select or hover over the button to see whether Windows is presenting grouped previews rather than separate buttons. Close and reopen Settings or sign out and back in if the taskbar does not update; save your work before restarting Windows.

Excel files open in the same place or you cannot find a workbook. Use View > Switch Windows to bring the required workbook forward. Check that a workbook is not minimized or hidden behind another window. You can also use Alt + Tab to cycle through open windows in Windows. On a Mac, the comparable app switcher shortcut is usually Command + Tab, but Mac does not have the Windows taskbar combine-buttons setting.

The buttons are separate on one monitor but not another. Return to Taskbar behaviors and look for the separate control for other taskbars. Set it to Never if that option is available. Also check that you are looking at the taskbar on the display where the Excel window is currently shown; Windows can place a window’s button on a different taskbar depending on your multi-display configuration.

You use Excel for the web. A workbook open in a browser is a browser tab, not a separate Excel desktop window. The taskbar setting can separate browser windows, but it cannot make each workbook tab into an individual Excel taskbar button. Open the desktop Excel app and open the workbooks there if you need separate Excel window buttons.

Frequently Asked Questions

Can I ungroup Excel on the taskbar without ungrouping other apps?
Not with the standard Windows combine-buttons setting. The Never option applies across apps. You can use View > Switch Windows in Excel to choose a workbook while leaving the taskbar grouped.

Why does Windows show one Excel icon when several workbooks are open?
The taskbar is likely combining Excel windows. Select or hover over the icon to view open-window previews, or set the combine-buttons option to Never to display separate buttons.

Will this change how Excel workbooks open?
No. It changes how Windows displays open windows on the taskbar. It does not change the workbook files, their contents, or Excel’s default file-opening behavior.

Does Never mean every sheet gets its own taskbar button?
No. It means each open window gets its own button. All worksheets inside one workbook window remain part of that window.

Can I do this in Excel for Mac?
There is no Windows taskbar on a Mac, so the Windows setting and steps do not apply. Use macOS window controls or Excel’s window menu to move between workbook windows.

Can I keep taskbar buttons separate only when Excel is open?
Windows’ built-in setting does not normally let you set a different combine rule for Excel alone. You can choose Never for all apps, or keep grouping and switch between workbooks using Excel’s window list or the taskbar previews.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.