Pivot Tables Flashcards
1
Q
Select entire pivot table
A
CtrlA
⌘A
2
Q
Toggle pivot table field checkbox
A
Space
Space
3
Q
Group pivot table items
A
AltShift→
⌘⇧K
4
Q
Ungroup pivot table items
A
AltShift←
⌘⇧J
5
Q
Hide pivot table item
A
Ctrl-
Ctrl-
6
Q
Create pivot chart on same worksheet
A
AltF1
7
Q
Create pivot chart on new worksheet
A
F11
FnF11
8
Q
Open pivot table wizard
A
AltDP
⌘⌥P