When you have well structured data, with consistent formulas, you can ask Excel to build an outline automatically. To ungroup, use the shortcut Alt Shift left arrow in Windows and Command Shift J on a Mac.Īgain, if you only have cells selected, you'll get a dialog, and you'll need to choose wether you want to ungroup rows or columns.īut when you have entire rows or columns selected, you can ungroup in one step. With entire rows or column selected, you can group in one step. You can speed things up by selecting entire rows or columns before you group. There, you can tell Excel to group either Rows or Columns. If you only have cells selected (not entire rows or columns) this shortcut will cause Excel to display the Group dialog box.

The shortcut for grouping rows or columns in Excel is Alt Shift right arrow in Windows and Command Shift K on a Mac.

In this worksheet, we have some basic data subtotaled by region and quarter. In this video, we'll look at shortcuts you can use to group, ungroup, and work with outlines.

How to show hotkeys in excel