Excel Pivot Table Shortcuts
Open Pivot Table Wizard
This Excel Shortcut opens the Pivot Table Wizard.

PC Shorcut:ALT>N>V
Mac Shorcut:⌘+⌥>P
Remember This Shortcut:
Alt is the command to activate the Ribbon shortcuts. N for Insert, V for Pivot
Alt is the command to activate the Ribbon shortcuts. N for Insert, V for Pivot
Create Pivot Chart On Same Worksheet
This Excel Shortcut creates a Pivot Table on the same worksheet.
PC Shorcut:ALT+F1
Create Pivot Chart On New Worksheet
This Excel Shortcut creates a Pivot Table on a new worksheet.
PC Shorcut:F11
Mac Shorcut:fn+F11
Select Entire Pivot Table
This Excel Shortcut selects the entire Pivot Table.
PC Shorcut:Ctrl+A
Mac Shorcut:⌘+A
Remember This Shortcut:
A for All
A for All
Group Pivot Table Items
This Excel Shortcut Groups Pivot Table items.
PC Shorcut:ALT+Shift+→
Mac Shorcut:⌘+⇧+K
Ungroup Pivot Table Items
This Excel Shortcut Ungroups Pivot Table items.
PC Shorcut:ALT+Shift+←
Mac Shorcut:⌘+⇧+J
Hide Pivot Table Item
This Excel Shortcut Hides a Pivot Table item.
PC Shorcut:Ctrl+–
Mac Shorcut:Ctrl+–
Toggle Pivot Table Field Checkbox
This Excel Shortcut toggles the Pivot Table Field checkbox.
PC Shorcut:Space
Mac Shorcut:Space