Ungroup in Excel: How to Bring Back the Ungroup Command

How-to basics · Updated November 20, 2026

To bring up Ungroup in Excel for Microsoft 365 on Windows, select the grouped rows or columns, then choose Data > Outline > Ungroup. If the command is unavailable, first check that you have selected a real row or column outline; grouped worksheet tabs and PivotTable groups use different Ungroup commands. Ungrouping removes the grouping structure, not the cells or their values.

What You’ll Need

  • An Excel workbook that contains grouped rows or columns, a grouped PivotTable field, or grouped worksheet tabs.
  • Permission to edit the workbook. A protected worksheet or read-only file can prevent changes.
  • For the steps below, Excel for Microsoft 365 on Windows. The corresponding Mac and web differences are noted where they matter.

Step-by-Step

  1. Identify what is grouped. Look at the sheet and its tabs before choosing a command. Row or column outlines have level buttons such as 1, 2, or 3 and plus or minus controls beside the row numbers or above the column letters. A PivotTable group appears among its row or column labels, often as grouped dates or number ranges. Grouped worksheet tabs are highlighted together; Excel may also show [Group] in the title bar. These are different features, so the correct Ungroup command depends on what you see.
  2. Open the Data tab and make the ribbon visible. Click Data at the top of Excel. If the ribbon is minimized, click a tab to reveal it, or press Ctrl+F1 on Windows to toggle the ribbon display. Look for the Outline group, usually toward the right side of the Data ribbon. If the window is narrow, the group or its commands may be condensed; maximize the Excel window or expand the ribbon to find them. On Mac, click the Data tab and locate the outline controls on that ribbon; ribbon layout and shortcuts differ from Windows.
  3. Select the rows or columns you want to ungroup. For a row outline, select the row numbers for the grouped rows, or select cells within the group if Excel can identify the relevant outline from that selection. Selecting the row headers is the clearest option when you need to target a particular section. For a column outline, select the column letters instead. If you select only a cell outside the grouped range, Ungroup may be greyed out because Excel has no relevant outline selection. When groups are nested, use the row or column headers around the specific level you intend to remove rather than selecting the entire sheet.
  4. Choose Ungroup. On Windows, use Data > Outline > Ungroup. If Excel opens a small dialog asking whether to ungroup Rows or Columns, choose the option that matches your selection and confirm. The outline brackets and controls for the selected group should change or disappear. If Ungroup has a drop-down arrow, its additional options can include commands for managing the outline; do not choose a clear-all option unless you mean to remove every outline on the sheet.
  5. Check nested groups before repeating. An outline can have several levels. Removing one level may leave other plus/minus controls in place, which does not necessarily mean the command failed. Inspect the outline brackets and level buttons, select the next intended rows or columns, and run Ungroup again only if you want to remove another level. If your goal is simply to see the hidden detail, use the plus sign or an outline level button instead; expanding a group reveals rows without removing the group structure.
  6. Use the PivotTable command for PivotTable groups. Click a grouped item inside the PivotTable, such as a grouped month or a numeric range. Open PivotTable Analyze > Ungroup on Windows. Depending on the ribbon layout, the tab may appear only while the PivotTable is selected. You can also right-click the grouped item and choose Ungroup if that option is available. The command reverses the field grouping; it does not delete the source records. For example, ungrouping grouped dates returns the individual date items to the PivotTable, subject to the source data and PivotTable settings.
  7. Ungroup worksheet tabs separately. If several sheet tabs are selected as a group, right-click one of the selected tabs and choose Ungroup Sheets, or click a sheet tab that is not part of the selection. Do not use Data > Outline > Ungroup for this. Grouped sheets can cause edits to be applied to multiple sheets at once, so confirm that the tab highlighting and any [Group] indicator have gone away before making further edits.
  8. Verify the result and save. Check that the intended outline, PivotTable grouping, or sheet-tab selection has changed, while the underlying data remains present. If you need to keep the previous arrangement, use Ctrl+Z on Windows immediately after the change; on Mac, use Command+Z. Undo may not be available after closing the workbook or performing other actions, so save a copy first if the workbook is important.

Common Mistakes

  • Looking for Ungroup on the wrong tab. Worksheet row and column outlines use Data > Outline > Ungroup. PivotTable groups use the PivotTable Analyze tab, while grouped sheet tabs use the sheet-tab context menu. Identify the object first.
  • Selecting cells that are not in the outline. A click in a nearby cell does not always tell Excel which outline to change. Select the relevant row numbers or column letters, especially when several separate groups are on the same sheet.
  • Confusing hidden rows with grouped rows. A hidden row may have no outline bracket or level buttons. Ungroup will not unhide it. Use Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns as appropriate.
  • Expecting Ungroup to erase data or formulas. The command removes a grouping relationship; it should not delete the selected cells’ contents. Avoid deleting rows or columns if all you want is to remove the outline.
  • Clearing every outline by accident. A clear-outline command removes all row and column outline levels on the sheet, not just the currently selected group. Use regular Ungroup for a targeted change.

Tips

  • Save a working copy before changing a complex or nested outline. It gives you a safe comparison if the result is not what you expected.
  • Use the outline level buttons at the upper-left of the worksheet to show a broad view of the data. For instance, selecting a lower level can display summaries while leaving detail rows grouped. This is a display choice, not the same as ungrouping.
  • When you only need to open one collapsed section, click its plus sign rather than ungrouping. The minus sign collapses it again, and the outline remains available for later use.
  • For many separate groups, work on one section at a time and inspect the brackets after each change. This helps avoid removing a higher-level outline than intended.
  • On Excel for Mac, the Data ribbon contains outline controls, but the exact placement can vary by window size and release. On Excel for the web, check the Data tab for available outline commands. If a needed command is missing, open the workbook in the desktop app rather than assuming a row is merely ungroupable.

Troubleshooting

Ungroup is greyed out. Confirm that the workbook is not read-only and that the worksheet is not protected. On Windows, check Review > Unprotect Sheet; if the sheet is password-protected, you need the password or help from the workbook owner. Then select the relevant row or column headers and check that outline brackets are present. If the selection is inside a PivotTable, switch to its PivotTable Analyze tab instead.

I cannot see the Outline group. Expand the ribbon, widen or maximize the Excel window, and look across the Data tab for condensed groups or a menu. If the ribbon has been customized, use Excel Options to check the ribbon display, or reset the ribbon only if you are comfortable losing customizations. Excel for the web and Mac may arrange controls differently; the desktop Windows path is Data > Outline > Ungroup.

The rows are hidden, but there are no plus signs. They may have been hidden manually rather than grouped. Select the row headers immediately above and below the missing rows, then choose Home > Format > Hide & Unhide > Unhide Rows. For columns, select the neighboring column headers and choose Unhide Columns. Also check whether a filter is hiding records; clear or adjust the filter rather than using Ungroup.

Ungroup changes the wrong level or leaves controls behind. Nested outlines can remain after one level is removed. Undo immediately if the result is wrong, then select a narrower or more precise set of row or column headers and try again. If you want to remove all outlines from the worksheet, use the clear-outline option from the Outline controls only after confirming that every group should be removed.

The PivotTable Ungroup option is missing or disabled. Click an actual grouped label inside the PivotTable, not a blank cell or a value outside it. Check that the PivotTable is editable and that you are on the contextual PivotTable Analyze tab. A PivotTable based on certain external or OLAP data sources may not allow the same manual grouping controls; in that case, change the grouping in the source or connection, or use a standard PivotTable source if appropriate.

Frequently Asked Questions

Where is Ungroup in Excel?
For grouped worksheet rows or columns, select the relevant group and choose Data > Outline > Ungroup on Windows. PivotTables and grouped sheet tabs use separate commands.

Why is Ungroup greyed out?
Common reasons include selecting outside the grouped range, choosing ordinary hidden rows rather than an outline, protecting the sheet, or being in a PivotTable without selecting a grouped item.

Does Ungroup delete rows or data?
No. Ungroup removes the outline relationship or PivotTable grouping; it is not a delete command. The detail remains in the worksheet or source data.

How do I ungroup every row or column outline at once?
Use the clear-outline option in the worksheet’s Outline controls if you intend to remove all outline levels on that sheet. It affects the whole sheet’s outline, so use regular Ungroup for a single group.

How do I expand a group without ungrouping it?
Click the plus sign beside the row group or above the column group, or use an outline level button to show more detail. The group remains and can be collapsed again.

Is the command different on a Mac or in Excel for the web?
The ribbon layout and shortcuts can differ. On Mac, look on the Data tab for the outline command; in the web app, use the available Data-tab controls. If the command you need is not offered, open the workbook in Excel for Microsoft 365 desktop.

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.