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.

Thank you for your clear explanation on the sumifs function. It was exactly what I needed to simplify a massive spreadsheet where I need to summarize a range of amounts from over 70 sheets in a workbook. The previous person would manually update the formulas each year but now the "sumifs between dates" formula will automate this. Huge Thanks!! -Sarah

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables