Excel’s grouping feature is one of the basic Excel features that helps you visualize data and quickly analyze it for faster decision-making. In other words, it lets you group rows or columns based on specific criteria, making large amounts of data easier to organize and analyze.
Excel Grouping Shortcuts
Here are the shortcuts for both Windows and Mac.
Windows Shortcuts
- Group: Alt + Shift + →
- Ungroup: Alt + Shift + ←
Mac Shortcuts
- Group: Command(⌘) + Shift(⇧) + K
- Ungroup: Command(⌘) + Shift(⇧) + J