Group rows or columns

Quickly show or hide rows or columns by grouping them together.

EQ

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!

Quick Tip

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

  1. Select the rows or columns you want to group together.
  2. Use the following keyboard shortcut to group them:
ActionShortcut
Group rows or columns togetherAlt + Shift +
Keyboard shortcut to group rows or columns together

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

  1. Select the grouped rows or columns that you want to ungroup.
  2. Use the following keyboard shortcut to ungroup them:
ActionShortcut
Ungroup rows or columnsAlt + Shift +
Keyboard shortcut to ungroup rows or columns

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:

ActionShortcut
Expand the current groupAlt then A then J
Collapse the current groupAlt then A then H
Keyboard shortcuts to expand or collapse grouped rows or columns


Bonus Tip

Please log in to see the bonus tip.

No login?
Get one for free.

Don’t have a login?

Get a login for free on our standard plan, and get a new tip each week.

Get started >>

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

Get quicker >>

View our plans to see what else you are missing, or join for free on our Standard plan.

 

Expert Tip

Please log in to see the expert tip.

Don’t have a login? Get one.

Download files for this tip

Get Quicksheet

Quicksheet

Download example

Example file

No login?
Get one for free.

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?

Get one >>

For more information about publication schedules and access to tips, see our plans.

Share this tip