Shortcuts to group, ungroup, and outline

In this worksheet, we have some basic data subtotaled by region and quarter.

There, you’ve got the option to tell Excel to group either Rows or Columns.

you’re free to speed things up by selecting entire rows or columns before you group.

With entire rows or columns selected, you might group in one step.

To ungroup, use the shortcut Alt Shift left arrow in Windows and Command Shift J on a Mac.

However, any hidden rows or columns will remain hidden.