| Windows | Mac |
|---|---|
| AltShift→ | ⌘⇧K |
About This Shortcut
This shortcut will display the Group Dialog Box as long as no whole rows or columns are selected.
Open Group Dialog Box
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.
Thank you. I now can use index match with multiple criteria. I feel i have just jumped to next level Excel expert.
Emily
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
