Group Rows and Columns in Excel (Alt + Shift + Right Arrow)
Grouping rows or columns allows you to organize your worksheet by collapsing or expanding sections for better readability and reporting.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + Shift + Right Arrow | Option + Command + K |
What Does This Shortcut Do?
The shortcut groups the selected rows or columns, adding a collapsible outline to manage the visibility of sections quickly.
How to Group Rows or Columns
- Select the rows or columns you want to group
- Press Alt + Shift + Right Arrow (Windows) or Option + Command + K (Mac)
- The selected rows or columns will now be grouped with a collapsible outline
Tips & Best Practices
- Use grouping to hide details while keeping summaries visible
- Combine with subtotal and outline features for structured reports
- You can collapse or expand groups using the small "+" or "−" icons next to the row or column headers
FAQ
- Q: Can I group multiple rows or columns at once?
- A: Yes, select all the rows or columns you want to group before using the shortcut.
- Q: Does grouping affect formulas?
- No, formulas continue to work normally even if the grouped rows or columns are hidden.
- Q: How do I remove a group?
- Use Alt + Shift + Left Arrow (Windows) or Option + Command + J (Mac) to ungroup, or right-click and select "Ungroup".