Group rows or columns
Quickly show or hide rows or columns by grouping them together.
This tip enables you to quickly show or hide groups of rows or columns.
The Quick Tip shows how to group rows or columns.
The Bonus Tip lets you customize the way grouped rows and columns behave.
Extending this tip using the Expert Tip can show or hide any row or column with one keyboard shortcut.
We hope you find these tips useful.
Excel Quicker!
Group rows or columns together
To make it easy to quickly show or hide groups of rows or columns, you can group them together like this:
How to group rows or columns together
- Select the rows or columns you want to group together.
- Use the following keyboard shortcut to group them:
| Action | Shortcut |
|---|---|
| Group rows or columns together | Alt + Shift + → |
This shortcut will create a new outline group with the selected rows or columns.
If they are part of an existing group, it will create a subgroup.
How to ungroup rows or columns
- Select the grouped rows or columns that you want to ungroup.
- Use the following keyboard shortcut to ungroup them:
| Action | Shortcut |
|---|---|
| Ungroup rows or columns | Alt + Shift + ← |
How to expand and collapse grouped rows or columns
When you have rows or columns grouped, you can expand or collapse each group to show or hide those rows or columns quickly.
To expand or collapse a group, select any cell within that group and then use these shortcuts:
| Action | Shortcut |
|---|---|
| Expand the current group | Alt then A then J |
| Collapse the current group | Alt then A then H |
Don’t have a login?
Get a login for free on our standard plan, and get a new tip each week.
All logins also get access to the bonus tip each week.
Get even more
Get even more with one of our reasonably priced paid plans, with access to features like:
- Quicksheet PDF summaries
- Example files
- VBA syntax
- Additional expert tips each week
- Advance publication
View our plans to see what else you are missing, or join for free on our Standard plan.
Delayed schedule
This tip is on the Delayed Schedule. It works just like normal, but it’s old news.
To view the current Tip of the week, log in with an account that has access to our Advance Publication schedule.
Don’t have a login?
For more information about publication schedules and access to tips, see our plans.