Excel How to Ungroup Cells: Rows, Columns & Sheets

How-to basics · Updated November 22, 2026

To ungroup cells in Excel, select the grouped rows or columns, then go to the Data tab and click the Ungroup button (or press Shift+Alt+Left Arrow on Windows, ⌘+Shift+J on Mac). If you’re dealing with a grouped worksheet (multiple sheets selected), right-click any sheet tab and choose Ungroup Sheets. This removes the outline grouping while keeping your data intact.

What “Grouping” Actually Means in Excel

Excel’s grouping feature creates an outline that lets you collapse or expand a set of rows or columns with a single click. It’s a visual and structural tool—it doesn’t merge cells, delete data, or change values. You’ll see a bracket (outline bar) on the left side for rows or on the top for columns, with a minus (–) or plus (+) button to collapse/expand.

Grouping is often confused with merging cells. Merging combines multiple cells into one large cell (used for headers), while grouping keeps each cell separate but links their visibility. Ungrouping only removes the outline—it never unmerges cells. If you actually need to split merged cells, select them and go to Home > Merge & Center > Unmerge Cells.

How to Ungroup Rows or Columns (Step-by-Step)

  1. Select the rows or columns that are currently grouped. You can click and drag over the row numbers or column letters, or hold Ctrl to pick multiple groups.
  2. Go to the Data tab on the ribbon.
  3. In the Outline group, click Ungroup (the icon with an arrow pointing outward).
  4. Alternatively, press Shift+Alt+Left Arrow (Windows) or ⌘+Shift+J (Mac).
  5. If you have multiple nested groups, Excel may ask if you want to ungroup the entire group or just the selected rows/columns—choose accordingly.

To remove all groupings at once, select the entire sheet (click the triangle where row numbers and column letters meet), then go to Data > Ungroup > Clear Outline. This removes every outline level in one go.

Ungrouping a Worksheet (Multiple Sheets)

Sometimes “grouped cells” actually refers to grouped sheets. When you select multiple sheet tabs (e.g., hold Ctrl and click several tabs), Excel puts them into “group mode.” The title bar shows [Group], and any edit you make applies to all selected sheets. To ungroup:

  • Right-click any selected sheet tab and choose Ungroup Sheets.
  • Or click any sheet tab that is not selected (if you only have grouped sheets, right-click and pick Ungroup).
  • Keyboard shortcut: Shift+F11 inserts a new sheet and automatically ungroups—but that adds a sheet, so it’s not ideal.

This is a common point of confusion: users see “grouped” in the title bar and think their cells are grouped, but it’s actually the sheet tabs.

Why Ungrouping Might Not Work (Common Problems)

  • You selected the wrong range: You must select the exact rows/columns that are grouped. If you select only part of a group, Excel may grey out the Ungroup button.
  • Protected sheet: If the worksheet is protected, grouping/ungrouping is disabled. Go to Review > Unprotect Sheet (you may need a password).
  • Grouped sheets: If you’re in sheet group mode, the Data tab’s Ungroup button might not appear for rows/columns. Ungroup the sheets first.
  • Nested groups: When groups are inside groups, you may need to ungroup the inner group first, then the outer one. Excel’s prompt will ask which level you want to remove.
  • Outline symbols hidden: If you don’t see the outline bars, go to File > Options > Advanced, and under “Display options for this worksheet,” check “Show outline symbols if an outline is applied.”

Ungrouping vs. Hiding/Unhiding

Grouping is often used as a fancy way to hide rows. If you collapse a group, the rows are hidden, but they’re still part of the outline. To truly ungroup, you must use the Ungroup command—just unhiding rows (right-click > Unhide) does not remove the grouping structure. The outline bar will remain, and you can still collapse the group again.

Similarly, if you select hidden rows and try to ungroup, Excel will often fail because hidden rows are hard to select. First, unhide the rows (select the surrounding rows, right-click > Unhide), then ungroup.

Keyboard Shortcuts and Mac Differences

  • Windows: Ungroup rows/columns: Shift+Alt+Left Arrow. Group: Shift+Alt+Right Arrow.
  • Mac: Ungroup: ⌘+Shift+J. Group: ⌘+Shift+K (on newer Excel versions).
  • Excel for the web: The Data tab has Ungroup, but keyboard shortcuts may not work consistently—use the ribbon button.

If you’re using Excel 2016 or older, the Mac shortcut might be ⌘+Shift+J as well, but some versions use ⌘+Option+Shift+J—check the Data tab tooltip.

Alternatives: When Not to Use Grouping

If you’re grouping to organize data, consider these alternatives:

  • Filters: Use Data > Filter to temporarily hide rows based on criteria—no permanent structure.
  • Tables: Convert data to a table (Ctrl+T) for better sorting and filtering, plus structured references.
  • PivotTables: For summarizing large datasets, grouping in a PivotTable is different—you can group dates or numbers, but that’s a separate feature.
  • Freeze Panes: If you’re grouping to keep headers visible, use View > Freeze Panes instead.

Grouping is best for collapsible sections in a report or dashboard. If you just want to hide rows temporarily, hiding is simpler.

Frequently Asked Questions

Does ungrouping delete my data?

No. Ungrouping only removes the outline structure. All cell values, formulas, and formatting remain exactly as they were. The only thing that disappears is the collapse/expand button and the outline bar.

Why is the Ungroup button greyed out?

This usually happens when you haven’t selected the full grouped range, or when the sheet is protected. Check that you’ve selected entire rows/columns that are part of a group, and unprotect the sheet if needed. Also, if you’re in sheet group mode, ungroup the sheets first.

How do I ungroup all rows at once?

Select the entire sheet (click the triangle at the top-left corner, or press Ctrl+A twice), then go to Data > Ungroup > Clear Outline. This removes every grouping level in the sheet.

Can I ungroup cells that are merged?

No—merging and grouping are different. To unmerge merged cells, select them, go to Home > Merge & Center and click the drop-down arrow, then choose Unmerge Cells. Grouping doesn’t merge cells, so ungrouping won’t affect merged ones.

What’s the difference between ungrouping and unhiding?

Unhiding (right-click > Unhide) makes hidden rows/columns visible again but leaves the grouping outline intact. Ungrouping removes the outline entirely, so you can’t collapse them again. If you want to keep the ability to collapse, just unhide; if you want to get rid of the structure, ungroup.

Does ungrouping work on grouped sheets?

No, it’s a different feature. For grouped sheets (multiple tabs selected), right-click a tab and choose Ungroup Sheets. The Data tab’s Ungroup button only affects row/column outlines within a single sheet.

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.