Pivot Table Shortcuts Flashcards
1
Q
Open Pivot Table Wizard
A
Alt > N > V
2
Q
Create Pivot Chart On Same Worksheet
A
Alt + F1
3
Q
Create Pivot Chart On New Worksheet
A
F11
4
Q
Select Entire Pivot Table
A
Ctrl + A
5
Q
Group Pivot Table Items
A
Alt + Shift + Right Arrow
6
Q
Ungroup Pivot Table Items
A
Alt + Shift + Left Arrow
7
Q
Hide Pivot Table Item
A
Ctrl + -
8
Q
Toggle Pivot Table Field Checkbox
A
Space
