Create a Pivot Table
Master this Excel shortcut with our comprehensive guide
Pivot Table Shortcuts
Alt, N, V
⌘ + Option + P
How to Use This Shortcut
Keyboard Shortcut
Alt, N, V
Instructions
1. Press Alt, then N, then V sequentially
2. Opens the Create PivotTable dialog box
3. Select your data range and location for the pivot table
2. Opens the Create PivotTable dialog box
3. Select your data range and location for the pivot table
Keyboard Shortcut
⌘ + Option + P
Instructions
1. Press Command + Option + P
2. Opens the PivotTable creation dialog box
2. Opens the PivotTable creation dialog box
💡 Pro Tip: Quickly summarize large datasets and generate reports in seconds.
Quick Actions
More Pivot Table Shortcuts
Alt, N, S, T
Alt + H
Alt + F5