In Excel for Microsoft 365 on Windows, select the grouped rows or columns and press Alt+Shift+Left Arrow to ungroup them. On Mac, use Option+Shift+Left Arrow; if the shortcut is unavailable, select the relevant rows or columns and choose Data > Ungroup.
The Excel ungroup shortcut and what it targets
The shortcut applies to row and column outlines: Excel’s feature for collapsing and expanding sections of a worksheet. It removes an outline grouping from the selected rows or columns. It does not delete the cells, clear their contents, or remove a group of worksheet tabs. Those are separate situations with different steps.
For the shortcut to act on the intended group, make a selection that intersects the outlined rows or columns. You can select cells within the section, or select its row or column headers. Choosing the headers makes the target clearer, especially when the sheet contains both row and column outlines. Then press the platform-specific shortcut once and check the outline controls at the edge of the grid.
- Windows: Alt+Shift+Left Arrow
- Mac: Option+Shift+Left Arrow
- Ribbon alternative: Data > Ungroup
How to ungroup rows or columns
Use these steps when a worksheet has collapsible sections marked by outline bars, level buttons, or plus and minus controls:
- Click a cell inside the grouped section, or select the row numbers or column letters belonging to it.
- Press Alt+Shift+Left Arrow on Windows, or Option+Shift+Left Arrow on Mac.
- If Excel asks whether to ungroup rows or columns, choose the correct option and confirm.
- Check that the outline level or bracket for the intended section has changed. If the group remains, check whether the selection intersected the right level of a nested outline.
You can also use the ribbon instead of the shortcut. Select the outlined rows or columns, open Data > Ungroup, and choose the appropriate option if Excel presents a choice. The ribbon route is useful when you are unsure which shortcut applies or when another application, keyboard layout, or remote desktop session intercepts the key combination.
What ungrouping changes—and what it leaves alone
Excel grouping is a way to organize and temporarily hide detail. For example, a monthly report might show a subtotal row while allowing a reader to collapse the individual transactions above it. Ungrouping removes that outline relationship. The rows and their values remain in the worksheet; they simply stop behaving as members of that particular collapsible group.
Ungroup is different from Hide. Hiding rows or columns changes their visibility without necessarily removing an outline. Ungrouping removes the grouping structure itself. It is also different from deleting rows or columns, which removes worksheet cells and can affect formulas or other references. If your goal is only to reveal hidden detail, use the outline’s plus button or the relevant level button instead of ungrouping.
Excel outlines can have multiple levels. A yearly report might group transactions within each month and then group the months within a year. Removing one group can leave an outer or inner group intact. If the result is not what you expected, inspect the remaining outline brackets and level controls before repeating the command; pressing Ungroup repeatedly can remove more structure than intended.
Choosing the right selection for a group
A common source of confusion is selecting the wrong part of the worksheet. For row groups, click the row numbers at the left. For column groups, click the column letters at the top. You can select several adjacent headers by dragging across them or using Shift while selecting the range. Selecting a cell within a group can also work, but headers make it easier to tell Excel whether you mean rows or columns.
For instance, if rows 5 through 12 contain detail for a subtotal in row 13, select those row headers and use the shortcut to remove their row outline. If columns C through F are grouped to hide quarterly figures, select those column headers before ungrouping. Do not select the subtotal row or a nearby unrelated section just because it is visible: make the selection correspond to the group you actually want to remove.
When row and column outlines overlap, Excel may need you to specify which direction to ungroup. Choose Rows for horizontal sections of the sheet and Columns for vertical sections. If Excel does not show a choice, verify the active selection and use the ribbon command to see whether the correct outline is being targeted.
Why the shortcut may not work
If nothing happens, first confirm that the active worksheet actually contains an outline group. A plus or minus button, numbered outline level, or bracket beside the row or column headers is a useful clue. Filter buttons, hidden rows, and manually hidden columns can look like grouped data but are not the same feature, so the ungroup shortcut will not necessarily change them.
- No group is selected: Click inside the outlined area or select its row or column headers, then try again.
- The wrong outline direction is active: Select row headers for row groups or column letters for column groups.
- The shortcut is intercepted: On laptops, keyboard layouts or remote-access software may affect key combinations. Use Data > Ungroup as a direct alternative.
- The data is hidden rather than grouped: Use the worksheet’s Unhide command or the relevant plus control, depending on how it was hidden.
- The sheet is protected: Protection can restrict structural changes. Check the Review tab and the workbook’s permissions before attempting to modify the outline.
Also check that you are not trying to ungroup worksheet tabs. Excel uses the word “group” for both outline sections and multiple selected sheets, but the row-and-column shortcut is intended for outlines. The distinction matters because editing a grouped set of sheets can change several worksheets at once.
Ungrouping worksheet tabs is a different task
When multiple sheet tabs are selected, Excel groups worksheets. This is sometimes done to enter the same heading or formatting on several sheets at once. While sheets are grouped, edits made to one selected sheet may be applied to the others as well. The outline shortcut does not separate these tabs.
To ungroup worksheets, right-click one of the selected sheet tabs and choose Ungroup Sheets. You can also click a sheet tab that is not part of the selected group, if one is available. Before making further edits, check that only the intended sheet tab is selected. On Windows, Ctrl+Shift+Page Up and Ctrl+Shift+Page Down can select adjacent worksheets, so it is possible to create a sheet group unintentionally while navigating.
If you entered or formatted data while sheets were grouped, review the other affected worksheets. Ungrouping stops future edits from being applied across the group, but it does not reverse changes already made to multiple sheets. Use Undo promptly if you need to reverse a recent edit and the workbook’s history still permits it.
Ungroup, expand, hide, and clear outline: the difference
Choose the command that matches your goal. To see details temporarily, expand a group using its plus control or an outline level button. To keep the data but remove the collapse-and-expand structure, use Ungroup. To hide rows or columns manually, use the Home tab’s Format options or the context menu; to show hidden rows or columns, use Unhide. These actions affect visibility or structure in different ways.
Excel also provides Data > Ungroup > Clear Outline in desktop versions that show the full Outline controls. Clear Outline removes the worksheet’s outline structure, rather than just ungrouping the selected section. Use it only when you intend to remove all outline groupings from that sheet. If you only want to remove one section, use Ungroup on the appropriate selection instead.
When you need to preserve the ability to collapse detail, avoid clearing the outline just to make one section visible. Expanding the relevant group is reversible and keeps the report’s organization. Conversely, if an outline is no longer useful and has become confusing, clearing it can be a deliberate cleanup step—but check all levels first.
Excel for Mac and Excel for the web
In Excel for Mac, the corresponding outline shortcut is Option+Shift+Left Arrow. The ribbon command is available through Data > Ungroup. Depending on your keyboard, macOS settings, or the version of Excel, the key combination may be captured by the system or another app. In that case, use the ribbon command rather than assuming the workbook has no group.
Excel for the web runs in a browser, where browser shortcuts and keyboard handling can differ from the desktop app. If the shortcut does not work there, use the available Data tab controls to ungroup the selected rows or columns. The exact controls can vary with the web interface and account, so the desktop Windows shortcut is the clearest reference for Excel for Microsoft 365 on Windows.
Frequently Asked Questions
What is the shortcut to ungroup rows in Excel?
On Windows, select the grouped rows and press Alt+Shift+Left Arrow. On Mac, use Option+Shift+Left Arrow. You can also use Data > Ungroup.
How do I ungroup columns in Excel?
Select the grouped column letters, then use Alt+Shift+Left Arrow on Windows or Option+Shift+Left Arrow on Mac. If Excel asks what to ungroup, choose Columns.
Does ungrouping delete my data?
No. Ungrouping removes the outline relationship, not the cell contents. The data stays in place, although the rows or columns may become visible if they were collapsed.
How do I ungroup sheets in Excel?
Right-click one of the selected worksheet tabs and choose Ungroup Sheets, or click a sheet tab outside the group. The row-and-column ungroup shortcut does not ungroup worksheet tabs.
How can I undo an ungroup action?
Use Ctrl+Z on Windows or Command+Z on Mac immediately after the action, if Undo is available. If you have continued working or saved and closed the workbook, the action may no longer be in the undo history; consider restoring a previous version or backup.
Related
- Unmerge Cells in Excel on iPad: Step-by-Step
- Unmerge Cells in Excel: Shortcut Key and Steps for Windows
- How to Unlock an Excel Sheet or Workbook
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Show Unread Emails in Outlook and Keep Them VisibleTo show only unread emails in Outlook, open the inbox or folder you want to check and apply…
- Excel Find and Replace Blanks: How to Fill or ClearTo fill genuinely empty cells in Excel, select the range, choose Home > Find & Select > Go…
- Google Sheets Filter by Date Range: Steps and TipsYes. In Google Sheets, select your data, choose Data > Create a filter, then use the date column’s…
- Excel Power Query: Extract Text from a StringTo extract text in Excel Power Query, select the relevant column and use Transform > Extract to choose…
- Extract Data from Google Maps to Excel: Practical OptionsYou can move location data into Excel, but Google Maps does not provide a general-purpose button to export…
- Excel Data Analysis Experience: Skills, Tasks, and ProofExcel data analysis experience means being able to organize data, check its quality, use formulas or tools to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.