Ungroup Rows and Columns in Excel (Alt + Shift + Left Arrow)
Ungrouping rows or columns removes the collapsible outline, restoring the normal worksheet structure.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + Shift + Left Arrow | Option + Command + J |
What Does This Shortcut Do?
The shortcut removes grouping from the selected rows or columns, eliminating the collapsible outline.
How to Ungroup Rows or Columns
- Select the grouped rows or columns you want to ungroup
- Press Alt + Shift + Left Arrow (Windows) or Option + Command + J (Mac)
- The selected rows or columns will now be ungrouped
Tips & Best Practices
- Ensure you select the grouped rows or columns before using the shortcut
- Use ungrouping to restore the full visibility of data for editing or formatting
- You can also right-click the grouped rows or columns and choose "Ungroup"
FAQ
- Q: Can I ungroup multiple groups at once?
- A: Yes, select all the grouped rows or columns before applying the shortcut.
- Q: Does ungrouping affect formulas or data?
- No, all formulas and data remain intact after ungrouping.
- Q: How do I remove grouping manually?
- Right-click on the grouped rows or columns and choose "Ungroup".