How to Remove Group Rows in Excel

How-to basics · Updated November 21, 2026

To remove grouping from rows in Excel for Microsoft 365 on Windows, select a row in the group, then choose Data > Ungroup > Ungroup. This removes the outline grouping, not the worksheet data. To remove every row and column outline at once, choose Data > Ungroup > Clear Outline instead. If you mean deleting the rows themselves, use Delete Sheet Rows; that permanently removes their contents from the worksheet.

What You’ll Need

  • An Excel workbook with grouped or outlined rows. Grouped sections are usually marked by outline levels and plus or minus buttons beside the row numbers.
  • Permission to edit the workbook. If the sheet is protected, you may need the password or help from the workbook owner before changing its outline.
  • A saved copy if you are unsure whether the grouping or the row data should be removed. Ungrouping is usually reversible with Undo, but deleting rows can affect formulas and references.

The steps below focus on Excel for Microsoft 365 on Windows. Excel for Mac has the same basic Ungroup and Clear Outline commands on the Data tab, though the ribbon layout can vary by window size. If you are using Excel for the web, open the workbook in the desktop app if you cannot find the outline commands.

Step-by-Step

  1. Check that the rows are grouped. Look to the left of the row numbers for outline controls: a minus button usually means a section is expanded, and a plus button usually means it is collapsed. Numbered outline level buttons may appear near the upper-left corner of the sheet. If there are no outline controls, the rows may be hidden manually or by a filter rather than grouped.
  2. Expand a collapsed group before selecting rows. Click the plus button beside the group to show its rows. If multiple sections are collapsed, expand the sections you need to work with. This makes it easier to select the correct row range and inspect what is included. You can also use the outline level buttons to show more detail; choosing the highest level generally displays the most detailed view of the outline.
  3. Select a row inside the group. Click a row number in the grouped section. For a simple group, selecting a row within it is often enough for Excel to identify the outline level to remove. If the sheet contains nested groups or you are not sure which section Excel will act on, select the full set of row headers belonging to the group. Drag down the row numbers or click the first row number, then Shift-click the last row number.
  4. Open the Ungroup command. Go to the Data tab on the ribbon. In the Outline group, open the Ungroup dropdown and choose Ungroup. If the ribbon is narrow, the Outline controls may be condensed or shown in a dropdown; widen the Excel window or look for the Outline section on Data. On Mac, use the Data tab and its Ungroup command; the exact arrangement can differ from Windows.
  5. Choose Rows if Excel asks. When the selected range could be ungrouped by row or by column, Excel may ask which direction to use. Choose Rows to remove the row grouping. If Excel does not ask, it uses the selected outline level. Inspect the sheet afterward: the relevant plus or minus controls should disappear or change, while the cell values remain in place.
  6. Repeat for other groups if needed. Ungroup usually removes one outline level at a time. If a section is nested inside another, removing its inner group may leave the outer group controls in place. Select a row in the remaining group and repeat Data > Ungroup > Ungroup until the outline level you want is gone. Stop when the surrounding groups you intend to keep are still available.
  7. Remove all outlines when you do not need any groups. If the worksheet has several grouped sections and you want to remove them all, go to Data > Ungroup > Clear Outline. This clears the worksheet outline rather than making you ungroup each section individually. Use it only when you are comfortable removing all outline groups, including groups you might otherwise want to retain. It does not delete the values in the cells.
  8. Check whether any rows are still hidden. Removing an outline and making every row visible are separate tasks. If rows remain hidden, select the row headers above and below the hidden section, right-click the selection, and choose Unhide. To unhide all worksheet rows, click the Select All button at the top-left corner of the grid, right-click a row number, and choose Unhide. Take care not to confuse hidden rows with deleted rows.
  9. Save and verify the worksheet. Scroll through the former group and confirm that the data is still present, the outline controls behave as expected, and formulas still refer to the intended cells. Save the workbook when you are satisfied. If you removed the wrong outline level, use Undo immediately or repeat the grouping process for the rows that should remain grouped.

For a quick example, imagine rows 5 through 12 contain monthly detail and are grouped under a summary in row 4. To remove only that group, select a row between 5 and 12 and use Ungroup. The details stay in rows 5 through 12; only the controls that let you collapse and expand that section are removed. If rows 5 through 12 are inside a larger group that also includes rows 13 through 20, you may need to ungroup the inner and outer levels separately, depending on how the outline was created.

Common Mistakes

  • Deleting rows when you only wanted to remove the outline. The Ungroup command removes the grouping feature while preserving cell contents. The Delete command removes worksheet rows and can shift other cells upward, change formulas, and affect linked charts or references. If the goal is simply to show detail without plus and minus controls, ungroup; do not delete.
  • Choosing Clear Outline for one small section. Clear Outline is a whole-worksheet cleanup command for the outline structure. It can remove groups you wanted to keep elsewhere on the sheet. Use Ungroup for a specific section and reserve Clear Outline for when you want to remove all outline groups.
  • Selecting the summary row instead of the grouped detail. A summary row may sit directly above or below the rows that expand and collapse. Select a row within the section controlled by the outline button, or carefully highlight the detail row headers. If the result is unexpected, undo before making other edits.
  • Assuming hidden rows are automatically deleted or restored. Grouping can hide detail when a section is collapsed, but manually hidden rows and filtered-out rows are different. Ungrouping will not necessarily remove a filter or correct manual hiding. Check the row numbers and the filter buttons before deciding what to do next.
  • Removing one nested level and expecting every control to vanish. Excel supports outlines with more than one level. A remaining plus or minus sign may belong to a parent group, not indicate that the first ungroup command failed. Expand the section and inspect the levels before clearing the entire outline.

Tips

  • Keep a copy before making broad changes. Save a separate workbook version before using Clear Outline on a complex report. This gives you a safe reference if you later need to restore the original outline arrangement.
  • Use outline levels to inspect a busy sheet. The numbered buttons let you change how much detail is displayed. They are useful for checking which rows belong to a summary before you ungroup. If controls are missing, check whether Excel is set to display outline symbols in the worksheet options.
  • Use the command that matches the scope. Ungroup targets a selected grouping level; Clear Outline removes all outline groups on the sheet. Choosing the narrower command reduces the chance of removing useful groups in a large report.
  • Consider filtering as an alternative when you need temporary focus. If the goal is to display only certain records, a filter may be more suitable than grouping. Filtering hides records that do not match criteria but does not reorganize the row outline. Remove or adjust a filter from Data > Filter rather than using Ungroup.
  • Remember that outline symbols may be turned off. A sheet can contain a grouping even when its plus and minus buttons are not visible. Check the Data tab for Ungroup or Clear Outline, and review Excel’s outline-symbol display setting before concluding that the sheet has no groups.
  • Use Undo promptly if the wrong level changes. Ctrl+Z on Windows reverses the most recent action. On Mac, use Command+Z. Undo may not be available after closing the workbook or after some other actions, so avoid continuing to edit if you need to reverse an accidental ungroup.

Troubleshooting

Ungroup is unavailable or grayed out. Confirm that you selected rows belonging to an outline and that the correct worksheet is active. If the sheet is protected, go to Review and check whether you can use Unprotect Sheet; a password may be required. Also check that you are not editing a cell or working in a view that prevents the command from being used.

The plus and minus buttons do not appear. First select a row in the suspected group and look for an active Ungroup or Clear Outline command on Data. If an outline exists but its controls are hidden, open Excel Options, choose Advanced, find the display options for this worksheet, and turn on Show outline symbols if an outline is applied. On Mac, check Excel’s application preferences for worksheet display options; labels and placement can vary by release.

Rows remain hidden after ungrouping. Check whether the row numbers skip a range, which can indicate manually hidden rows. Select the row headers around the gap, right-click, and choose Unhide. If filter arrows are active, clear or change the filter from Data > Filter. A collapsed group, manual hiding, and a filter can look similar, but each needs a different fix.

Only some grouping controls disappeared. The sheet probably has nested outline levels or several separate groups. Expand the remaining sections and repeat Ungroup for each level you want to remove. If none of the groupings should remain, use Clear Outline once instead of repeatedly ungrouping individual sections.

Ungroup changed the wrong rows. Press Ctrl+Z on Windows or Command+Z on Mac before doing more work. Then expand the outline, select the intended row range by its row numbers, and try again. For a complicated sheet, save a copy and test the command on one section first.

The rows look like a group, but Ungroup does nothing. The rows may have been hidden manually, filtered, or concealed by a different feature. Check for gaps in row numbering, active filter indicators, and the outline buttons. If the rows are simply hidden, use Unhide; if a filter is active, adjust or clear it. Do not delete the rows unless removing their data is genuinely your goal.

Frequently Asked Questions

Does ungrouping rows delete their data?
No. Ungroup removes the outline structure used to collapse and expand the selected rows. It leaves the worksheet rows and their cell contents in place. Use Delete Sheet Rows only if you intend to remove the rows themselves.

How do I remove all grouped rows at once?
Choose Data > Ungroup > Clear Outline. This removes outline groups on the active worksheet, including groups you may have wanted to keep. It does not delete the cell data, so check the sheet afterward for manually hidden rows or filters.

Can I ungroup just one section?
Yes. Select a row inside that group, then choose Data > Ungroup > Ungroup. If the worksheet has nested levels, repeat the command only as needed and watch which outline controls remain.

Why do the rows stay hidden after I remove the group?
They may be hidden manually or excluded by a filter rather than hidden by the outline. Select the affected row headers and use Unhide, or change the filter from Data > Filter. Removing a group and revealing rows are related but separate tasks.

Can I remove grouping in Excel for Mac?
Yes. On Mac, select the grouped rows and use Ungroup on the Data tab; Clear Outline is available for removing the outline structure. Ribbon placement can differ from Windows, so look in the Data tab’s outline controls.

What is the difference between Ungroup and Delete?
Ungroup removes the expand-and-collapse structure while keeping the rows and their contents. Delete Sheet Rows removes the selected worksheet rows and shifts other content. If you only want to get rid of the group buttons, choose Ungroup rather than Delete.

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.