Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Group rows Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for group rows in Excel.

Shortcut keys

WindowsAlt + Shift + →
MacCmd + Shift + K

Ribbon path

Data → Group

What it does

Groups selected rows so they can be collapsed/expanded with a click. Useful for organising large reports with sections.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for group rows?

On Windows, use Alt + Shift + →. On Mac, use Cmd + Shift + K.

Where is group rows in the Excel Ribbon?

The Ribbon path is Data → Group.

What does group rows do in Excel?

Groups selected rows so they can be collapsed/expanded with a click. Useful for organising large reports with sections.