How to Ungroup in Excel

Co-authored by wikiHow Staff

Last Updated: April 9, 2024 Tested

Although grouping data in Microsoft Excel can be a useful way to preserve consistent formatting, ungrouping it may be desirable if you wish to make sheet-specific changes. To ungroup sheets, right-click on one of the sheets and select "Ungroup" or press ⇧ Shift while clicking one of the grouped sheets. Similarly, ungrouping rows or columns is done by selecting the desired data range and choosing "Ungroup" from the "Data" tab (or using Windows/Mac keyboard shortcuts). Don’t forget to save your work before making changes to your groups!

Method 1

Method 1 of 3:

Ungrouping Worksheets

Download Article

The tabs for grouped sheets will be highlighted in a similar shading or color and the text on the tab of the active sheet in the group will be bold.
The sheets will ungroup and you can make changes without affecting all sheets.^{[1]
X
Research source}

Advertisement
^{[2]
X
Research source}
Press and hold Ctrl (Windows) or ⌘ Cmd (Mac) and left click the worksheet tabs you want grouped. The sheets will be grouped upon releasing the key.

Method 2

Method 2 of 3:

Ungrouping Manual Data Groups

Download Article

If your data was grouped with the “Group” button then it was done manually. Groups are sometimes created automatically by functions, like Subtotal, which can be identified by a “Subtitle” row under the grouped data.
This button is placed to the left of the spreadsheet. If the group is already expanded, a “-” is shown instead. Expanding will reveal any hidden groups or rows.
This is located in the top menu bar and will bring up a set of data-specific controls.
5
Click “Ungroup”. This button is on the right side of toolbar in the “Outline” section and will ungroup the selected area.^{[3]
X
Research source}
- You may also use a keyboard shortcut to ungroup selected rows or columns. Select the grouped columns and press Alt+⇧ Shift+← (Windows) or ⌘ Command+⇧ Shift+J (Mac).^{[4]
  X
  Research source}

Method 3

Method 3 of 3:

Ungrouping Automatic Data Groups

Download Article

If your data was grouped with the “Group” button then it was done manually. Groups are sometimes created automatically by functions, like Subtotal, which can be identified by a “Subtitle” row under the grouped data.
This is located in the top menu bar and will bring up a set of data-specific controls.
This button is on the right of the data toolbar in the "Outline" section and will bring up a dialog box.
This button is in the lower left of the dialog box and will ungroup all data and remove the subtotals.

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Video

Tips

You can save the file as a new version before working with the subtotal or grouping features in your spreadsheet. This will keep you from having to return it to its previous state after ungrouping and removing subtotals.

Thanks
Helpful 2 Not Helpful 2