Ungroup Excel Shortcut: Remove Row and Column Groups

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the grouped rows or columns and press Alt+Shift+Left Arrow to ungroup them. On a Mac, the equivalent shortcut is Option+Shift+Left Arrow; you can also use Data > Outline > Ungroup on the ribbon.

What the Ungroup Shortcut Does

Excel’s Ungroup command removes an outline group from selected rows or columns. It changes the worksheet’s grouping structure, not the cell contents: it does not delete the values, formulas, or formatting in those rows or columns. If the group was collapsed, check what is visible afterward, since changing an outline can affect how you see the affected rows.

The shortcut is the reverse of Excel’s grouping shortcut. For comparison, Alt+Shift+Right Arrow groups selected rows or columns on Windows, while Option+Shift+Right Arrow groups them on a Mac. The left arrow means ungroup; the right arrow means group. These shortcuts are for worksheet outlines, not for removing rows or columns from the sheet.

Ungrouping is different from expanding a group. Expanding reveals the rows or columns while keeping the outline group in place; ungrouping removes the group structure. If your goal is only to see hidden detail temporarily, use the outline’s plus button instead of the Ungroup shortcut.

How to Ungroup Rows or Columns

For predictable results, select the rows or columns that belong to the group you want to remove, then use the shortcut. Selecting the row or column headers makes it clear whether you intend to change a row outline or a column outline.

  1. Find the outline symbols beside the row numbers or above the column letters. A bracket and a minus or plus button indicate that the area is grouped.
  2. Select the grouped row numbers or column letters. For example, click the row numbers for the grouped detail rows, or drag across the column letters for a grouped set of columns.
  3. Press Alt+Shift+Left Arrow on Windows, or Option+Shift+Left Arrow on Mac.
  4. Look at the outline symbols and confirm that the intended grouping level has been removed. If the group remains, check for another nested level.

You can also use the ribbon: select the relevant rows or columns, choose Data > Outline > Ungroup, and follow any prompt Excel displays. If Excel needs to know whether you mean rows or columns, choose the appropriate option. The ribbon method is useful when a keyboard layout makes the arrow shortcut awkward or when you want to confirm the command before applying it.

Nested Groups and Outline Levels

A worksheet can contain more than one outline level. For example, a monthly report might group the individual transaction rows under each week, then group several weeks under each month. The outline buttons numbered 1, 2, and so on represent summary levels; the plus and minus controls expand or collapse a particular section.

When you ungroup part of a nested outline, Excel may remove one level while leaving another level intact. That is why a group can appear to remain after the shortcut: the visible bracket may belong to a parent group, or the selected rows may still have another outline level. Repeat the command only after checking which bracket and level you want to remove.

For a clear example, suppose rows 5 through 12 contain daily entries grouped under a weekly subtotal, and rows 4 through 14 are also grouped as a month. Ungrouping only the daily detail group can leave the broader monthly outline available. If you instead want to remove all worksheet outline groups, use Data > Outline > Ungroup and choose Clear Outline where that option is available. Clearing an outline removes the grouping structure across the sheet, so it is broader than ungrouping one selected section.

Ungrouping Is Not the Same as Showing or Hiding

Excel offers several commands that affect grouped data, and they solve different problems:

  • Expand or collapse: Click the plus or minus control beside a row group, or above a column group. This changes what is displayed while keeping the group.
  • Ungroup: Use Alt+Shift+Left Arrow or the ribbon command to remove the outline grouping from the selection.
  • Hide or unhide: Hide and unhide commands change row or column visibility, but they do not create or remove outline groups.
  • Clear Outline: Remove outline grouping from the worksheet rather than just the selected group.

A common misconception is that Ungroup deletes the grouped data. It does not. Another is that pressing the minus button ungrouped the rows; it only collapsed them. If you want the rows to remain available but no longer be controlled as a group, use Ungroup. If you just want a compact report view, collapse the group instead.

Ungrouping PivotTable Items

PivotTables can group items too, but that grouping belongs to the PivotTable rather than to a worksheet row or column outline. For example, a date field may be grouped into months and quarters, or numeric values may be grouped into ranges. The worksheet outline shortcut is not the most reliable way to remove this kind of grouping.

To ungroup PivotTable items, click one of the grouped items in the PivotTable and choose PivotTable Analyze > Group > Ungroup. Depending on the Excel build and platform, the tab may be named Analyze rather than PivotTable Analyze. Check that the selected cell is inside the grouped PivotTable field; selecting an unrelated worksheet cell will not expose the relevant command.

After ungrouping, the PivotTable may show the original field items again, such as individual dates instead of month labels. This changes how the PivotTable summarizes its source data, not the source records themselves. If the Ungroup command is unavailable, check that the PivotTable is selected and that the field is actually grouped. Some PivotTables based on particular data sources or models do not support every grouping operation.

Why the Shortcut May Not Work

If nothing happens, first check that Excel has focus and that you are not editing a cell. Press Enter or Esc to leave cell-edit mode, select the grouped row or column headers, and try again. A selection of ordinary cells may not make the intended outline direction clear, so selecting the headers is a useful troubleshooting step.

  • The wrong kind of group is selected: A PivotTable’s grouped field uses its PivotTable commands. A worksheet outline uses the Data tab’s Outline commands.
  • The selection is outside the group: Select the rows or columns covered by the outline bracket, not just nearby cells.
  • The group is only collapsed: If the goal is to reveal detail, click the plus control. Ungrouping and expanding are different actions.
  • The sheet is protected: Protection can restrict structural changes. If you are authorized to edit the workbook, check the protection settings or ask the workbook owner for access.
  • The keyboard layout or device changes the keypress: Try the ribbon route, or check whether your laptop requires an Fn key to send the left-arrow key.

On Excel for the web, keyboard behavior can differ because the browser and operating system may reserve some key combinations. If the shortcut does not work, use the Data tab’s Ungroup command if it is available in your version, or open the workbook in the desktop app. On Mac, use Option rather than Alt for the equivalent outline shortcut.

Choosing the Right Method

The keyboard shortcut is fastest when you already know which grouped rows or columns you want to change. It is especially convenient while cleaning up a report with several separate outline sections. The ribbon is a better choice when you are unsure whether you selected rows or columns, when you need to inspect available options, or when a shortcut conflicts with your device’s keyboard behavior.

Before changing a complicated outline, consider what the workbook is meant to do. Groups may let readers collapse detail while keeping subtotals visible. Ungrouping a single section can simplify navigation without affecting other groups; clearing the entire outline removes that convenience across the worksheet. If you are preparing a file for someone else, retain useful summary controls unless there is a reason to remove them.

For a quick check, ask yourself whether you want to remove the outline or merely change the current view. Use the minus or plus control to change the view, Ungroup to remove a selected group, and Clear Outline only when you intend to remove the outline structure more broadly.

Frequently Asked Questions

What is the keyboard shortcut to ungroup in Excel?
On Windows, select the grouped rows or columns and press Alt+Shift+Left Arrow. On Mac, use Option+Shift+Left Arrow. These shortcuts apply to worksheet outline groups.

How do I ungroup rows in Excel without a keyboard shortcut?
Select the grouped row headers, then choose Data > Outline > Ungroup. If Excel asks whether to ungroup rows or columns, choose Rows.

Does ungrouping delete my data?
No. Ungrouping removes the outline grouping; it does not delete cell contents. Review which rows are visible afterward, particularly if the group was collapsed before you changed it.

How do I remove all groups from a worksheet?
Use the Data > Outline > Ungroup menu and choose Clear Outline if that option is shown. This is broader than ungrouping one selected section, so use it only when you want to remove the worksheet’s outline structure.

Why does Ungroup not work in my PivotTable?
Click a grouped PivotTable item, then use PivotTable Analyze > Group > Ungroup (or the Analyze tab on builds that use that shorter name). The worksheet outline shortcut and PivotTable grouping commands are separate features.

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.