Exceljet

Quick, clean, and to the point

Group rows or columns

Windows shortcut

AltShift→

Mac shortcut

⌘⇧K

This shortcut will group selected rows or selected columns. Select whole rows or columns first before using.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.

Shortcuts to group, ungroup, and outline

In this lesson, we cover shortcuts you can use to group and outline data.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Topics

Key functions

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. Read more.

I struggled for days with a Excel formula problem. I have several books on Excel including the Dummies series. Nothing helped. One hour on your website, and everything fell in place for me. Clear and concise instructions along with many excellent examples did the trick. -Grampi

Group rows or columns

Related videos

Download 200+ Excel Shortcuts

Excel video training