There are two types of groupings you can create in Excel: you can group sheets or you can group rows or columns in a subtotal. Either way, it's easy enough to create groups, but sometimes you may need to ungroup them again. By following the steps outlined in this article, you will learn how to divide groupings. Good fun!
Steps
Method 1 of 2: Separate Groups of Spreadsheets
Step 1. Identify the sheets that are grouped
Step 2. The labels of the grouped sheets will have a similar color or shading
Step 3. The label text of the active sheet of the group will appear in bold
Step 4. Separate the sheets
Step 5. Click on the label of any other sheet to deselect and separate the sheets
Step 6. Alternatively, you can right-click on one of the grouped sheets and choose the "Separate Sheets" option in the menu that appears
Method 2 of 2: Separate Groups of Rows and Columns
Step 1. Identify the method used to group, before starting to separate rows and columns
Step 2. The rows may have been automatically grouped using the “Subtotal” feature
In this case, a “Subtotal” line will appear just below the grouped lines. This row could cover, and thus make invisible, the individual grouped rows.
Step 3. The rows or columns may have been manually grouped through the “Group” feature
In this case, no “Subtotal” line will appear.
Expand the group by clicking on the button with the (+) symbol, which appears on the left or at the top of the page, just before the number of rows or columns
Step 4. If a button with a sign (-) appears, then the group has already been expanded
Step 5. Ungroup the group
Step 6. If you need to delete a row grouping that has been carried out automatically, then click on the "Subtotal" icon found in the "Groupings" command box and select "Remove All" in the window that appears
If, on the other hand, the rows or columns have been grouped manually, click and drag the mouse to select all the rows in the group and then click on the "Ungroup" icon found in the "Groupings" command box; select rows or columns and then press the OK key to close the window
Advice
- You can save the excel file as a new version before you start ungrouping. This way, you can easily return to the previous state.
- If the grouping was created by another user, you should discuss the reason with him before deleting it.
