To ungroup worksheets in Excel for Microsoft 365 on Windows, right-click one of the selected sheet tabs and choose Ungroup Sheets. To ungroup grouped rows or columns, select the relevant rows or columns, then choose Data > Outline > Ungroup. These actions remove the grouping, not the worksheet data.
What “ungroup” means in Excel
Excel uses grouping in a few different ways, so the right ungroup command depends on what you grouped. You might have selected several worksheet tabs to apply the same change across sheets, created collapsible row or column outlines, or grouped items inside a PivotTable. Each type has its own control.
A quick visual clue is to look at the workbook. Multiple selected sheet tabs indicate grouped worksheets. Numbered outline buttons and plus or minus signs beside row or column headings indicate an outline. A field that displays grouped dates or number ranges in a PivotTable is a different kind of grouping again.
Ungrouping generally removes the shared selection or grouping structure. It does not delete the worksheet, rows, columns, or values. However, some commands can remove several outline levels at once, so check whether you want to remove one group or the whole outline before choosing them.
Ungroup multiple worksheets
When worksheet tabs are grouped, an edit made on the active sheet can also affect the other selected sheets. This is useful when setting up identical layouts, but it is easy to leave the sheets grouped and accidentally repeat a later change. Use this method to return to working on one sheet at a time:
- Find the selected worksheet tabs along the bottom of the Excel window. A grouped selection may show [Group] in the title bar, depending on the workbook and window.
- Right-click any selected sheet tab.
- Choose Ungroup Sheets from the context menu.
The grouped selection ends, and subsequent edits apply to the active worksheet rather than to all of those tabs together. Another way to end the selection is to click a sheet tab that is not in the group, if one is available. The context-menu command is more explicit and useful when you want to confirm what you are doing.
To select several tabs again later, click the first tab and hold Ctrl while clicking other individual tabs. To select a continuous range, click the first tab, hold Shift, and click the last tab. On a Mac, use Command-click for separate tabs and Shift-click for a range. If you do not see Ungroup Sheets, check that more than one sheet is selected; it is not the command for an ordinary single worksheet tab.
Ungroup outlined rows or columns
Row and column outlines let you collapse detail while keeping summary rows or columns visible. The outline controls appear near the worksheet headings: commonly, plus and minus buttons sit beside grouped rows or above grouped columns, with level buttons such as 1, 2, or 3 nearby. Ungrouping removes the outline relationship. It does not remove the rows, columns, or cell contents.
For a specific group in Excel for Microsoft 365 on Windows:
- Expand the group if necessary so you can identify the rows or columns involved. Expanding is not required in every case, but it makes it easier to select the intended section.
- Select the row numbers or column letters that belong to the group you want to remove.
- Open Data > Outline > Ungroup, then choose Ungroup Rows or Ungroup Columns when Excel offers the choice.
You can also select the relevant rows or columns and press Shift+Alt+Left Arrow on Windows. If Excel cannot determine whether you mean rows or columns, use the ribbon command and select the correct option. On Mac, keyboard shortcuts can vary with the keyboard and Excel version; use the Data tab command if the Windows shortcut does not apply.
Do not choose Clear Outline unless you intend to remove the outline structure from the worksheet, not just one selected group. It clears the worksheet’s outline groups, while leaving the underlying cell data in place. If you need to preserve other sections’ collapsible controls, ungroup only the intended rows or columns instead.
Ungroup items in a PivotTable
PivotTable grouping is separate from worksheet and outline grouping. For example, Excel can group dates into months or years, or group numeric values into intervals. To reverse a PivotTable grouping, click a grouped label or item in the PivotTable and choose PivotTable Analyze > Group > Ungroup. You can also right-click a grouped item and choose Ungroup when that option is available in the context menu.
Ungrouping a date field can return the PivotTable to individual dates; ungrouping numeric ranges can return it to the original individual values. The source data is not changed by this command, but the PivotTable layout and displayed categories can change. If the command is unavailable, check that the selected cell is actually inside the grouped PivotTable field rather than in a nearby worksheet cell.
What changes—and what stays the same
Ungrouping is usually a structural change, not a data deletion. Knowing what to expect helps distinguish a successful ungroup from an accidental edit:
- Grouped worksheets: The sheets stop sharing a selection. Existing values and formatting remain as they were.
- Outlined rows or columns: The selected outline group is removed. Its rows or columns remain in the sheet, though their display may change if they were collapsed.
- PivotTable items: The grouped categories are separated in the PivotTable. The source table or range remains intact.
One potential surprise with an outline is that ungrouping does not necessarily make hidden rows visible. Rows may be hidden manually, by a filter, or by a collapsed outline. If they remain hidden after you remove a group, investigate those other causes rather than repeatedly ungrouping. Similarly, ungrouping sheets will not undo edits that were already made while the sheets were grouped.
Common problems and how to fix them
- There is no Ungroup Sheets command. You may have only one sheet selected, or you may have right-clicked a worksheet cell instead of a sheet tab. Right-click a selected tab and confirm that multiple tabs are grouped.
- Rows still look hidden. Check whether the outline is collapsed; use its plus button to expand it. If there is no outline control, select the surrounding row headings and use Home > Format > Hide & Unhide > Unhide Rows. A filter may also be hiding records.
- Ungroup is disabled for rows or columns. The selected area may not belong to an outline group, or the worksheet may be protected. Confirm that you selected the row numbers or column letters within the intended group and check whether editing is restricted.
- The whole outline disappeared. You may have used Clear Outline rather than ungrouping a selected section. The values remain, but the outline controls are removed. If the change was just made, use Ctrl+Z on Windows to undo it; undo availability can depend on later actions.
- The wrong sheets changed. If a worksheet edit was made while tabs were grouped, ungrouping will not reverse it. Undo the edit promptly with Ctrl+Z, if it is still in the undo history, and inspect each affected sheet. On Mac, the usual undo shortcut is Command+Z.
Excel for the web has fewer worksheet-management capabilities than the desktop application, and worksheet-tab grouping may not be available there. If the workbook needs a command that the web interface does not show, open it in the Excel desktop app. The exact availability of outline or PivotTable controls can also depend on the workbook and the version being used.
How to avoid accidental grouped edits
Before typing, formatting, clearing cells, or inserting rows, glance at the sheet tabs. If several are highlighted or the title bar indicates a group, decide whether the change should affect every selected sheet. If not, right-click a selected tab and choose Ungroup Sheets first.
When you intentionally group sheets, keep the selection limited to sheets with matching layouts. A change to a cell address is applied to the same address on each selected sheet, which can be useful for repeated headers but risky when sheets have different content. After completing the shared task, ungroup the tabs and verify one or two sheets before continuing.
For outline groups, use the minus button to collapse and the plus button to expand when you only need to change what is visible. These controls do not remove the grouping. Choose Ungroup only when you no longer need that collapsible structure.
Frequently Asked Questions
How do I ungroup sheets in Excel quickly?
Right-click any selected worksheet tab and choose Ungroup Sheets. If another unselected sheet tab is visible, clicking it also ends the grouped selection.
Does ungrouping delete rows or data?
No. Ungrouping worksheet tabs, outline rows or columns, or PivotTable items removes a grouping relationship. It does not, by itself, delete the underlying worksheets, cell values, or source data.
How do I ungroup rows without removing every outline?
Select the row headings in the group, then use Data > Outline > Ungroup and choose Ungroup Rows. Avoid Clear Outline, which removes the outline structure from the worksheet.
Why are rows still hidden after I ungroup them?
They may still be collapsed, manually hidden, or excluded by a filter. Expand the outline if it remains, use the row-heading unhide command for manually hidden rows, and check whether a filter is active.
Can I ungroup worksheets in Excel for the web?
Worksheet grouping controls may be unavailable in Excel for the web. Open the workbook in the Excel desktop app for the worksheet-tab grouping commands if they are missing online.
How do I undo an ungroup command?
Try Ctrl+Z on Windows or Command+Z on Mac immediately after the change. Excel’s undo history can be affected by subsequent actions, and not every action can be reversed indefinitely.
Related
- Can You Auto Capitalize in Excel? Methods That Work
- Can You Capitalize Words in Excel? Methods That Work
- Can You Align Shapes in Excel? A Practical Guide to Layout
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Duplicate a Text Box in Excel Without Rebuilding ItTo duplicate a text box in Excel for Microsoft 365 on Windows, click its outer border so the…
- Google Sheets: Count Dropdown Values in a Column EasilyTo count how many times a particular dropdown choice appears in Google Sheets, use =COUNTIF(B2:B100,"Approved"), replacing the range…
- Remove Formatting in Word: Keyboard Shortcuts ExplainedIn Microsoft Word for Windows, press Ctrl+Spacebar to remove direct character formatting, such as manually applied bold or…
- How to Freeze Multiple Columns in Excel While ScrollingTo freeze several columns in Excel, select the cell immediately to the right of the columns you want…
- Excel Goal Seek: How It Works and When to Use ItIn Excel, Goal Seek is a What-If Analysis tool—not a worksheet function—that finds the input value needed to…
- Excel Split Multiline Cell Into RowsYes. In Excel for Microsoft 365, enter =TEXTSPLIT(SUBSTITUTE(A2,CHAR(13),""),,CHAR(10),TRUE) in an empty cell to split the line breaks in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.