Pivot Tables

ShortcutWindowsMac
Select entire pivot table Ctrl A A
Toggle pivot table field checkbox Space Space
Group pivot table items Alt Shift K
Ungroup pivot table items Alt Shift J
Hide pivot table item Ctrl - Ctrl -
Create pivot chart on same worksheet Alt F1
Create pivot chart on new worksheet F11 Fn F11
Open pivot table wizard Alt D P P