| Windows | Mac |
|---|---|
| AltShift→ | ⌘⇧K |
About This Shortcut
This shortcut will group selected rows or selected columns. Select whole rows or columns first before using.
Group rows or columns
Related videos
Shortcuts to group, ungroup, and outline
In this video, we’ll look at shortcuts you can use to group, ungroup, and work with outlines.
In this worksheet, we have some basic data subtotaled by region and quarter.
The shortcut for grouping rows or columns in Excel is Alt + Shift+ Right arrow in Windows and Command Shift K on a Mac.
If you …
Author
Dave Bruns
Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
I work as a Financial Controller and I do all kinds of calculations, reports, etc. and I try to be as efficient (and clever) as possible using various formulas and Excel tricks. When I have some issue in Excel almost every time I find solutions on your web pages. The explanations of various topics are great and understandable at first glance.
Zdeněk
Get Training
Quick, clean, and to the point training
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles
