Excel group rows shortcut (Alt+Shift+Right arrow)

Group rows in Excel: Alt+Shift+Right arrow (Mac: Cmd+Shift+K)

Windows	`Alt+Shift+Right arrow`
Mac	`Cmd+Shift+K`
Group	grouping and structure

Practice this shortcut

Drill: Group the detail rows. Pro drill. Twenty-five drills are free.

What it does and when to use it

Select the detail rows and press Alt+Shift+Right. An outline bracket appears in the margin with a minus button to collapse them. Grouped detail under subtotals is what makes a long schedule readable.

The common mistake

Grouping with cells selected instead of rows, which asks whether you mean rows or columns. Shift+Space first.

Related shortcuts

Insert a column Ctrl+Space, Ctrl+Shift+=
Delete a blank row Shift+Space, Ctrl+-
Ungroup rows Alt+Shift+Left arrow
Collapse the groups Alt, A, H
Insert a sheet Shift+F11
The printable cheat sheet

Questions

How do I group rows in Excel without the mouse?

Select the rows with Shift+Space and press Alt+Shift+Right. Alt+Shift+Left ungroups.

Learn it by pressing it

Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.

Start the drill