In Excel for Microsoft 365 on Windows, select a cell in the grouped rows or columns and press Shift+Alt+Left Arrow to ungroup them. On a Mac, use Option+Shift+Left Arrow; the ribbon alternative is Data > Outline > Ungroup.
Ungroup shortcut in Excel for Windows
The ungroup shortcut removes an outline grouping from the selected rows or columns. Select a cell inside the group you want to remove, then press Shift+Alt+Left Arrow. You can also select the relevant row or column headings first if you want to make the target more explicit. Excel updates the outline controls at the edge of the worksheet when the grouping is removed.
The shortcut is the reverse of the grouping shortcut: Alt+Shift+Right Arrow groups selected rows or columns, while Alt+Shift+Left Arrow ungroups them. The order in which you press Alt and Shift does not change the shortcut. Use the left-arrow key as the final key, not the minus key on the numeric keypad.
These commands affect worksheet structure, not the values or formulas in the cells. Ungrouping does not erase rows, columns, labels, calculations, or formatting. It removes a grouping level so that the grouped rows or columns are no longer controlled as one outline unit.
How to use the shortcut safely
Before pressing the shortcut, identify whether the outline is for rows or columns and select a cell or heading that belongs to the intended group. If the worksheet contains several groups, avoid selecting a large area that spans unrelated groups unless you mean to change all of them. A small, deliberate selection makes the result easier to predict.
- Click a cell within the grouped rows or columns, or select their row or column headings.
- Press Shift+Alt+Left Arrow on Windows.
- If Excel displays an Ungroup dialog, choose Rows or Columns as appropriate and confirm.
- Check the outline controls and the affected rows or columns to confirm that the intended grouping was removed.
If nothing appears to happen, inspect the outline symbols around the worksheet. A minus or plus button beside row numbers usually indicates row grouping; the equivalent controls above the column letters indicate column grouping. A cell merely being hidden does not prove it is grouped, so the outline symbols are useful evidence before you try again.
What ungroup changes—and what it leaves alone
Grouping creates an outline that can collapse and expand rows or columns. For example, a worksheet might group daily transaction rows under each month, letting a reader collapse the details and keep summary rows visible. Ungrouping removes that outline relationship. The underlying transaction records remain in their original cells; they are not deleted or moved.
After ungrouping, rows or columns that were hidden by collapsing a group may become visible, because the outline no longer controls their visibility. However, ungrouping is not the same as unhiding manually hidden rows or columns. If rows remain missing, select the surrounding row headings and use Home > Format > Hide & Unhide > Unhide Rows. For columns, use the corresponding Unhide Columns command.
Ungrouping also does not undo a subtotal calculation or remove subtotal rows. A worksheet made with Excel’s Subtotal feature can contain both summary formulas and outline groups. Removing a group changes the outline; it does not automatically remove the formulas or the subtotal rows. If the goal is to remove those calculations, examine the worksheet separately before deleting anything.
Ungroup rows versus columns
The keyboard command can apply to either row groups or column groups, but the selection tells Excel what you intend to change. To remove a row group, select a cell in the grouped rows or select the row headings. To remove a column group, select a cell in the grouped columns or select the column headings. If the selection does not make the target clear, Excel may ask whether to ungroup rows or columns.
For example, a monthly report may have detail rows grouped beneath each monthly total, while separate columns group quarterly detail beneath annual totals. Clicking in a row group and ungrouping it should not be treated as a command to remove the column outline as well. Work on one dimension at a time, then verify the matching controls: row outline buttons appear beside the row numbers, and column outline buttons appear above the column letters.
If a selection includes both grouped rows and grouped columns, use the dialog or the ribbon command and choose the intended direction. Do not assume that selecting an entire worksheet will cleanly remove every outline. A broad selection can make it harder to tell which level Excel will change, particularly when the worksheet has nested groups.
Nested outlines and partial ungrouping
Excel supports outline levels, so a worksheet can contain groups within larger groups. A project plan might group individual task rows by phase and then group several phases into a larger project section. In that arrangement, ungrouping one level may leave another level intact. The remaining plus and minus buttons are not necessarily a sign that the shortcut failed; they may represent a different outline level.
When working with nested groups, select within the specific inner or outer group you want to remove and use the shortcut once. Inspect the result before repeating it. If the group remains but its level changes, the worksheet may contain more than one level. Repeatedly pressing the shortcut without checking can remove additional outline structure that you intended to keep.
Excel’s numbered outline buttons, usually shown above the row numbers or to the left of the column letters, let you display different outline levels. They collapse or expand what is shown, but they do not themselves remove groups. The shortcut and Ungroup command change the outline structure; the numbered buttons change the current display of that structure.
Ribbon and menu alternatives
If you forget the shortcut or prefer visible controls, use the ribbon. Select a cell or headings in the group, then choose Data > Outline > Ungroup. Depending on the ribbon layout, Ungroup may have a drop-down arrow. Use the command for the selected rows or columns, and choose the appropriate option if Excel asks which direction to apply it.
The ribbon is especially useful when you are unsure whether a region is grouped or when a keyboard shortcut is being intercepted by another program or keyboard layout. It also makes it easier to distinguish Ungroup from Clear Outline. Ungroup removes a selected grouping level; Clear Outline removes the worksheet’s outline structure more broadly. Use the broader option only when you intend to remove all outline groups, not just one local group.
Undo may reverse an ungrouping action in many ordinary editing situations: press Ctrl+Z on Windows or Command+Z on a Mac. Still, check the worksheet after using Undo, especially if you have performed other actions since ungrouping. If the worksheet is important, save a copy before making broad structural changes.
Excel for Mac and Excel for the web
In Excel for Mac, the equivalent shortcut is generally Option+Shift+Left Arrow, with Option taking the place of Alt. Keyboard layouts and macOS settings can affect how shortcuts behave, so use the ribbon if the key combination is intercepted or does not respond. The menu route is through the Data tab and its Outline controls, as in Windows.
Excel for the web runs in a browser, and browser or operating-system shortcuts can sometimes take priority over Excel shortcuts. If the key combination does not work, use the Data tab’s Ungroup command when it is available in the ribbon. Excel for the web may not present every desktop control in exactly the same place, so the visible ribbon labels are a more dependable guide than assuming that every desktop keyboard command behaves identically online.
These differences do not change what ungrouping means: it removes outline grouping rather than deleting worksheet content. If a workbook is shared, a change to its grouping structure can affect what other collaborators see, so confirm that the outline is no longer needed before saving the change.
Common problems and fixes
When the shortcut seems ineffective, first check whether the selected cells are actually part of a group. A manually hidden row, a filtered-out record, or a collapsed PivotTable field can look similar to an outline group but is controlled differently. Look for outline brackets and plus or minus buttons at the worksheet edges. If those are absent, the issue may not be a normal row or column outline.
- The wrong direction is affected: Select a cell or headings in the intended row or column group, then try again. Use the Ungroup dialog to choose Rows or Columns if Excel offers it.
- Some groups remain: The sheet may contain nested outline levels or separate groups. Ungroup the intended level, checking the outline after each command.
- Rows are still hidden: They may have been hidden manually. Use the Unhide Rows or Unhide Columns command rather than repeating Ungroup.
- The command is unavailable: Check whether the worksheet is protected or whether the selection includes a suitable grouped area. Worksheet protection can restrict structural changes; the workbook owner may need to adjust protection settings.
- The key combination does something else: Try the Data tab’s Ungroup button. Keyboard layouts, browser shortcuts, and system settings can affect shortcut behavior.
Filtering is another frequent source of confusion. A filter hides records that do not meet its criteria, but it does not create an outline group. Clear or change the filter using the filter controls if the missing rows are filtered out. Similarly, a collapsed PivotTable has its own expand and collapse controls; ordinary Ungroup may not be the right tool for changing its layout.
Ungroup, hide, and clear outline compared
These commands solve different problems, even though each can change what is visible on a sheet. Ungroup removes a selected outline relationship. Hide conceals selected rows or columns without creating an outline. Clear Outline removes outline grouping across the worksheet. Choosing the right operation avoids accidentally removing useful structure while trying to reveal data.
- Use Ungroup when a particular row or column group is no longer needed but other outline groups should remain.
- Use Unhide when rows or columns were manually hidden and there is no outline group to remove.
- Use Clear Outline when the entire worksheet outline should be removed, including its grouping structure.
- Use a filter’s controls when records are hidden because they do not match filter criteria.
A useful example is a budget worksheet with department sections grouped for quick collapsing. If one department should remain permanently expanded but the other departments should still be collapsible, ungroup only that department’s rows. Clearing the whole outline would remove the controls for every department, while unhiding rows would not remove the outline that can collapse them again.
Frequently Asked Questions
What is the ungroup shortcut in Excel?
On Windows, select the grouped rows or columns and press Shift+Alt+Left Arrow. On a Mac, use Option+Shift+Left Arrow. If the shortcut is unavailable, use Data > Outline > Ungroup.
Does ungrouping delete rows or data?
No. Ungrouping removes the outline relationship; it does not delete cell values, formulas, or the rows and columns themselves. It may reveal rows or columns that were hidden by collapsing the group.
How do I ungroup only rows or only columns?
Select a cell or the headings in the intended grouped rows or columns before using Ungroup. If Excel asks which kind to change, select Rows or Columns. Check the outline buttons beside row numbers or above column letters afterward.
Why are rows still hidden after I ungroup?
They may be manually hidden, filtered out, or controlled by a PivotTable rather than a standard outline. Use the matching Unhide, filter, or PivotTable controls instead of repeating the ungroup command.
How do I remove all groups in a worksheet?
Use the Clear Outline option from the Data tab’s Outline controls. Unlike Ungroup, which removes a selected grouping, Clear Outline removes the worksheet’s outline structure more broadly. Review the sheet first if some groups are still useful.
Related
- Excel Strikethrough Shortcut: Fast Ways to Cross Out Text
- Compare Two Excel Spreadsheets Quickly: Best Methods
- Shade Every Other Row in Excel: Quick, Reliable Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Background Formatting in Word 2007: What to DoIn Word 2007, remove a page background with Page Layout > Page Color > No Color, or remove…
- Protect an Excel File From Opening With a PasswordTo stop people opening an Excel workbook without permission, open it in the Excel desktop app and choose…
- Wrap Text in Excel and Google Sheets: Step-by-StepTo wrap text, select the cell or range, then turn on wrapping: in Excel for Microsoft 365 on…
- Freeze Panes in Excel: How to Keep Rows and Columns VisibleTo insert a freeze pane in Excel for Microsoft 365 on Windows, select the cell immediately below the…
- Excel yyyy/mm/dd Text: Format and Convert Dates CorrectlyTo show a real Excel date as yyyy/mm/dd, select the cells, press Ctrl+1, choose Number > Custom, enter…
- How to Insert a Gray Line in Word: Shapes and BordersTo insert a gray line in Microsoft Word, go to Insert > Shapes > Line, draw the line,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.