Ungroup Cells in Excel: Keyboard Shortcut and Steps

How-to basics · Updated November 20, 2026

To ungroup outlined rows or columns in Excel for Microsoft 365 on Windows, select the grouped rows or columns and press Alt+Shift+Left Arrow. Excel removes the outline grouping from the selection; it does not delete the cells or their contents. Excel groups rows or columns, rather than individual cells, so first identify which kind of grouping you have.

What You’ll Need

  • An editable Excel workbook containing grouped rows or columns. The outline brackets, level buttons, plus signs, or minus signs beside the row or column headers can help you spot a group.
  • Permission to edit the sheet. If the worksheet is protected, you may need the password or the owner’s help before changing its outline.
  • A moment to check the selection before ungrouping. If the grouping is important to the workbook’s layout, consider saving a copy first.

Step-by-Step

  1. Identify what is grouped. Look along the left edge of the row numbers and above the column letters for outline brackets and numbered outline-level buttons. A minus sign usually means a group is expanded; a plus sign means it is collapsed. A bracket spanning row numbers indicates a row group, while one spanning column letters indicates a column group. If several worksheet tabs are highlighted, that is grouped sheets, not a row or column outline; see the troubleshooting section.
  2. Expand the group if needed. If the detail rows or columns are hidden behind a collapsed group, click its plus sign to show them. You can also click a higher outline-level button, such as 2 or 3, to display more detail. Expanding first makes it easier to see the group boundaries and select the right rows or columns. This changes what is visible, not the data.
  3. Select the rows or columns to ungroup. For a row group, select the relevant row headers by dragging over their numbers or by clicking the first header and Shift-clicking the last. For a column group, select the column headers in the same way. Select the full group if your goal is to remove that group, and avoid including neighboring groups unless you intend to change those too. Selecting headers is more reliable than selecting a few cells within the range because outlines apply to complete rows or columns.
  4. Use the Windows shortcut. With the intended rows or columns selected, press Alt+Shift+Left Arrow. If Excel displays an Ungroup dialog, choose Rows or Columns, as appropriate, and confirm. The shortcut removes the outline level for the selected direction; it does not erase cell values, formulas, formatting, or worksheet rows and columns.
  5. Use the ribbon if the shortcut is inconvenient. Select the row or column headers, open Data > Outline > Ungroup, and choose the matching option if Excel asks whether to ungroup rows or columns. The ribbon route is useful when you forget the shortcut, use a keyboard layout where the shortcut is awkward, or want to make sure you are choosing the right direction.
  6. Check the result. Look for the outline bracket or plus/minus control to disappear or change. If there are nested groups, some outline controls may remain because another level still exists. Click the remaining plus/minus buttons to check which rows or columns are still grouped. Verify that the data itself is still present and that the intended detail is visible.
  7. Repeat only for the remaining group levels you want to remove. A range can contain nested groups, such as individual detail rows inside a larger summary group. Ungrouping one level does not necessarily remove every level. Select the appropriate rows or columns and use the shortcut or ribbon command again only if you want to remove another level.

On a Mac: In Excel for Mac, select the grouped row or column headers and press Option+Shift+Left Arrow. You can also use the Data tab’s Ungroup command. Keyboard behavior can depend on the keyboard and macOS settings, so use the ribbon if the shortcut is captured by another feature.

In Excel for the web: Keyboard shortcuts can vary with the browser and may be intercepted by it. If the worksheet shows an Ungroup command on the Data tab, select the relevant headers and use that command. If the outline controls or command are unavailable, open the workbook in the desktop Excel app and ungroup it there.

Common Mistakes

  • Assuming individual cells are grouped. Excel’s outline Group and Ungroup commands apply to rows or columns. If you mean merged cells, use Home > Merge & Center > Unmerge Cells instead. Unmerging is a different action and can change how the contents are displayed.
  • Selecting the wrong direction. Row groups are identified by brackets beside row numbers; column groups are identified by brackets above column letters. If Excel presents a Rows or Columns choice, match it to the group you intend to remove.
  • Selecting too much or too little. Including adjacent rows or columns can remove grouping you wanted to keep. Selecting only a small portion of a complex outline may also leave other levels in place. Inspect the bracket boundaries and select the intended group’s headers before using the command.
  • Confusing hiding with grouping. A row hidden with Hide does not have an outline group to ungroup. Select the surrounding row headers, right-click, and choose Unhide if that is the issue. Similarly, a collapsed outline group should be expanded with its plus sign before you judge whether its rows have disappeared.
  • Using Clear Outline when you only want to remove one group. The Clear Outline command removes outline structure from the sheet more broadly. Use Ungroup for a selected group or level when you want to preserve other outline groups.

Tips

  • Save a copy before a large change. Ungrouping does not delete data, but it changes the sheet’s outline structure. A copy gives you a straightforward way to restore the original layout if you remove several nested levels by mistake.
  • Use the outline-level buttons to review a large sheet. Buttons numbered 1, 2, and so on show different levels of summary and detail. They help reveal whether a sheet contains nested outlines before you make changes. They are display controls, not ungroup commands.
  • Keep the summary and detail rows distinct. If totals sit above or below a group, include only the rows that belong to the outline when selecting. This reduces the chance of changing how a nearby summary section is organized.
  • Remember the shortcut as the reverse of grouping. In Windows Excel, Alt+Shift+Right Arrow groups selected rows or columns, while Alt+Shift+Left Arrow ungroups them. Confirm the selection before pressing either shortcut.
  • Use the command that matches the object. Grouped worksheet tabs, grouped outline rows or columns, PivotTable items, and merged cells are separate Excel features. Their ungrouping steps are not interchangeable, even though each may be described casually as “grouped cells.”

Troubleshooting

The shortcut does nothing: Confirm that the active cell is on the intended worksheet and that you selected the row or column headers for an outline group. Then try Data > Outline > Ungroup. On a laptop, check whether a function-key or system setting affects keyboard input; using the ribbon avoids that uncertainty. On Mac, try the ribbon if macOS or another app intercepts Option+Shift+Left Arrow.

Excel asks whether to ungroup rows or columns: This is a prompt to clarify the direction. Choose Rows for a bracket beside row numbers or Columns for a bracket above column letters. If you are not sure, cancel, inspect the outline, and select the correct headers before trying again.

The rows are still hidden afterward: Ungrouping and unhiding are different. If the outline bracket is gone but rows remain hidden, select the row headers above and below the gap, right-click, and choose Unhide. If the bracket remains, click the group’s plus sign to expand it or repeat Ungroup for another nested level that you also want to remove.

The Ungroup command is unavailable: Check whether the worksheet is protected. If it is, use Review > Unprotect Sheet if you have permission and any required password. Also check that the workbook is not open in a read-only state and that the selection contains rows or columns with an outline. If you cannot edit the sheet, ask its owner for access rather than trying to bypass protection.

Several worksheet tabs are highlighted: The sheets are grouped together, so edits can affect multiple worksheets at once. Right-click one of the selected sheet tabs and choose Ungroup Sheets, or click a sheet tab that is not part of the selection. This is different from ungrouping outlined rows or columns, and the row/column shortcut is not the right tool for it.

The sheet has merged cells or PivotTable groups: For merged cells, select them and use Home > Merge & Center > Unmerge Cells. For a grouped PivotTable item, right-click the grouped item and choose Ungroup, where available. If the command is unavailable, check the PivotTable selection and its source or layout. These operations change different structures from an ordinary worksheet outline.

Frequently Asked Questions

What is the shortcut to ungroup rows in Excel?
In Excel for Microsoft 365 on Windows, select the grouped rows and press Alt+Shift+Left Arrow. If prompted, choose Rows. On Mac, use Option+Shift+Left Arrow.

Does ungrouping delete cells or data?
No. Ungroup removes outline organization; it does not delete the selected rows, columns, values, or formulas. If you want to delete cells, rows, or columns, use the appropriate Delete command instead.

Can I ungroup just one level of a nested outline?
Usually, yes. Select the relevant grouped rows or columns and use Ungroup. Check the remaining brackets afterward: another bracket or plus/minus control can indicate a separate outline level that is still present.

Why do I see plus and minus signs beside the worksheet?
They are outline controls. A plus sign expands a collapsed group, and a minus sign collapses an expanded one. Use Ungroup to remove the outline grouping itself; clicking a plus or minus only changes what is displayed.

Is ungrouping worksheet tabs the same thing?
No. Grouped sheet tabs mean that multiple worksheets are selected together. Right-click a selected tab and choose Ungroup Sheets. The row and column shortcut applies to worksheet outlines, not to grouped tabs.

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.