How to Delete Grouping in Excel: Rows, Columns & Sheets

How-to basics · Updated November 20, 2026

To delete a row or column grouping in Excel, select the grouped rows or columns, then choose Data > Ungroup. To remove every outline group from the current worksheet, open the arrow beside Ungroup and choose Clear Outline. These commands remove the grouping structure, not the worksheet data. If you mean grouped worksheet tabs or grouped shapes, use the separate instructions below.

What You’ll Need

  • An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows.
  • Permission to edit the workbook. If the worksheet is protected, you may need its password or an authorized person to unprotect it first.
  • A quick check of what is grouped: rows or columns, worksheet tabs, or drawing objects. Each type has a different Ungroup command.

Step-by-Step

  1. Identify what Excel has grouped. Look at the worksheet and the ribbon before making changes. Row or column groups usually show numbered outline level buttons and small plus or minus signs along the left edge or above the column letters. Multiple selected worksheet tabs appear highlighted together, and Excel may show [Group] in the title bar. A group of shapes or pictures has a selection boundary around its objects. Identifying the type first helps avoid ungrouping the wrong thing.
  2. Save a copy if the outline is complex. Ungrouping does not erase cell values, but it changes how the sheet is organized and can affect which rows or columns are visible. If the worksheet has several nested outline levels or you are not sure how it was built, use File > Save As to create a working copy. This gives you a fallback if the result is not what you intended.
  3. Select the grouped rows or columns. For a row group, select the row numbers within the outline you want to remove. For a column group, select the column letters. You can select the whole group, including its detail rows or columns, to remove that grouping level. If groups are nested, start with the innermost group you want to remove. Selecting a group’s summary row alone may not target the detail rows that belong to it.
  4. Ungroup the selected rows or columns. Choose Data > Ungroup in the ribbon’s Outline area. If Excel asks whether to ungroup rows or columns, choose the appropriate option and confirm. The plus or minus control for that group should disappear. Its cells remain in the worksheet; only the outline relationship is removed. On Windows, the keyboard shortcut is Shift+Alt+Left Arrow after selecting the rows or columns. On Mac, use Option+Shift+Left Arrow if that shortcut is available in your Excel version; otherwise use the ribbon command.
  5. Repeat for other levels, if needed. A sheet can contain nested groups, such as a group for each month inside a larger group for each quarter. Ungrouping one level does not necessarily remove the others. Select the next level and repeat Data > Ungroup. Check the outline buttons and plus or minus controls after each action so you can stop once the desired level is gone.
  6. Remove all row and column outlines at once, if that is your goal. Click the arrow beside Data > Ungroup, then choose Clear Outline. This clears the outline grouping structure from the active worksheet, including its nested row and column groups. Use it only when you want all outline groups on that sheet removed; it is broader than ungrouping a selected range. It does not clear the worksheet’s cell contents.
  7. Ungroup worksheet tabs if several sheets are selected. Click a worksheet tab that is not part of the selection, or right-click one of the selected tabs and choose Ungroup Sheets. On Windows, hold Ctrl while clicking tabs to select or deselect individual sheets; on Mac, use Command-click. If the tabs are consecutive, Shift-click can select a range. Ungrouping the sheets stops future edits from being applied to all selected sheets together; it does not delete any sheets or undo edits already made.
  8. Ungroup shapes or pictures separately. Click the grouped drawing objects to select their outer group. Open the contextual Shape Format tab, choose Group > Ungroup, and confirm if prompted. Depending on the selected object and Excel build, the contextual tab may be called Graphics Format or Picture Format. If you cannot select the group on the sheet, use Home > Find & Select > Selection Pane to locate and select it, then use the format tab’s Group command.

Common Mistakes

  • Choosing Clear Outline when you only meant to remove one group. Clear Outline affects every row and column outline on the active sheet. Use Ungroup on a selected range for a targeted change.
  • Assuming ungrouping deletes data. Ungrouping removes the outline or shared-selection state; it is not a delete-rows or delete-columns command. Check the worksheet contents before using any separate delete command.
  • Confusing hidden rows with grouped rows. A row can be hidden manually without being in an outline group. If there are no outline controls, Ungroup may not reveal it. Use the row headers and the Unhide command instead.
  • Leaving worksheets grouped. When multiple tabs are selected, a change made to one sheet can also be made to the others. Ungroup sheets before entering or editing data if you did not intend to make the same change across them.
  • Trying to ungroup only part of a nested group. Outline levels can overlap. Select the rows or columns that correspond to the specific level you want to remove, and check the result before clearing the entire outline.

Tips

  • Use the outline level buttons, usually numbered 1, 2, and so on, to see how much detail is currently displayed. A minus sign collapses a group; a plus sign expands it. Expanding is not the same as deleting the group.
  • When you want to keep the outline but show its details, click the plus sign or choose a more detailed outline level. That preserves the grouping controls for later use.
  • After ungrouping a range, inspect both its beginning and end. If the wrong rows or columns changed, press Ctrl+Z on Windows or Command+Z on Mac immediately to undo, then make a more precise selection.
  • If the ribbon is simplified or the window is narrow, the Outline commands may be compressed or hidden in a menu on the Data tab. Maximize the window or expand the ribbon to find Ungroup.
  • For large sheets, note the selected row numbers or column letters before using Clear Outline. The command acts on the active worksheet, so confirm you are on the intended tab.

Troubleshooting

Ungroup is unavailable or greyed out. Confirm that you selected rows or columns belonging to an outline, rather than an ordinary cell range. Check whether the worksheet is protected; if it is, use Review > Unprotect Sheet if you are authorized and have the required password. A shared or restricted workbook may also limit structural changes. If you are in Excel for the web and cannot find the relevant outline command, open the workbook in the desktop app and try the Data tab there.

The plus and minus signs are gone, but some rows are still missing. Ungrouping and unhiding are different actions. Select the row headers on either side of the missing rows, right-click the selection, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Rows. For hidden columns, select the neighboring column letters and choose Unhide Columns from the same menu. If rows remain hidden after ungrouping, check for a filter as well: clear or adjust the filter rather than repeatedly using Ungroup.

Only one level disappeared. That is normal for nested outlines. Expand the remaining groups if necessary, select the rows or columns at the next level, and repeat Ungroup. If the goal is to remove every outline on that worksheet, use Clear Outline instead. Be aware that this removes all outline levels on that sheet, not just the visible one.

Edits are still affecting more than one worksheet. Check the sheet tabs for multiple selections. Right-click a selected tab and choose Ungroup Sheets. Then make a small, harmless check in the active sheet, or review the tabs’ selection state, before continuing with important edits. If changes were already copied to other sheets, ungrouping stops future linked edits but does not reverse those earlier changes; use Undo promptly or restore from a saved copy.

The Group command for a shape is missing. Make sure the selection is a group of compatible drawing objects, not a cell range or a chart element. Select the outer group rather than an individual item and look for the contextual Shape Format, Graphics Format, or Picture Format tab. If an object is inside another group, you may need to ungroup the outer group first or select the item through the Selection Pane.

Frequently Asked Questions

Does deleting a grouping delete the rows or columns?
No. Ungroup removes the outline relationship and its controls. It does not remove the cells, values, or formulas. Use a separate delete command only if you actually want to remove worksheet rows or columns.

How do I remove grouping without expanding everything first?
Select the grouped row numbers or column letters and choose Data > Ungroup. If you need to remove all outline levels, choose Clear Outline from the arrow beside Ungroup. The display may change as the outline is removed, but the underlying cell data remains.

Can I undo an ungroup action?
Usually, press Ctrl+Z on Windows or Command+Z on Mac immediately after the action. Undo may not be available after saving, closing, or performing later actions, so save a copy first when the outline is important.

What if Grouping was created in a PivotTable?
PivotTable grouping is separate from worksheet outlining. Select a grouped item in the PivotTable, then use PivotTable Analyze > Ungroup when that command is available. The PivotTable Analyze tab appears when a PivotTable cell is selected; do not use Clear Outline for this task.

Does Ungroup Sheets remove the worksheets?
No. It only ends the selection of multiple tabs as a group. All selected worksheets remain in the workbook, and any edits already made while the tabs were grouped remain in place.

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.