How to use the GROUP PIVOT TABLE ITEMS Keyboard Shortcut in Excel

Using the Group Pivot Table Items Shortcut

Windows keyboard shortcut

Mac keyboard shortcut

Use this Excel shortcut to group pivot table items. If you are grouping a field by date or number, only one item in the field needs to be selected prior to using this shortcut.

Discover 242 Excel Keyboard Shortcuts for Windows and Mac

Other useful Pivot Table keyboard shortcuts

Select Entire Pivot Table

Toggle Pivot Table Field Checkbox

Ungroup Pivot Table Items

Hide Pivot Table

Create Pivot Chart on Same Worksheet

Excel GROUP PIVOT TABLE ITEMS Keyboard Shortcut

Using the Group Pivot Table Items Shortcut