Excel Pivot Table Shortcuts

Open Pivot Table Wizard

This Excel Shortcut opens the Pivot Table Wizard.

Open 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

Create Pivot Chart On Same Worksheet

This Excel Shortcut creates a Pivot Table on the same worksheet.

PC Shorcut:ALT+F1

AutoMacro - VBA Code Generator

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

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