How to Ungroup in Excel
Identify the sheets that are grouped., Right-click one of the grouped sheet tabs and choose "Ungroup Sheets" from the pop-up menu., Alternately, Press ⇧ Shift while clicking an active sheet within the current group., Regroup worksheets after making...
Step-by-Step Guide
-
Step 1: Identify the sheets that are grouped.
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. -
Step 2: Right-click one of the grouped sheet tabs and choose "Ungroup Sheets" from the pop-up menu.
The sheets will ungroup and you can make changes without affecting all sheets.,, 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. -
Step 3: Alternately
-
Step 4: Press ⇧ Shift while clicking an active sheet within the current group.
-
Step 5: Regroup worksheets after making changes (optional).
Detailed Guide
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.,, 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.
About the Author
Catherine Adams
Writer and educator with a focus on practical hobbies knowledge.
Rate This Guide
How helpful was this guide? Click to rate: