Pivot Table

ActionWindows ShortcutMac Shortcut
Create a Pivot TableAlt + N, VControl + Option + P
Refresh a Pivot TableAlt + F5Command + Option + F5
Select Entire Pivot TableCtrl + ACommand + A
Expand/Collapse FieldAlt + Left/Right ArrowOption + Left/Right Arrow
Move to Next Pivot FieldTabTab
Move to Previous Pivot FieldShift + TabShift + Tab
Toggle Field ListCtrl + F1Command + Option + F
Group Items in Pivot TableAlt + Shift + Right ArrowOption + Shift + Right Arrow
Ungroup Items in Pivot TableAlt + Shift + Left ArrowOption + Shift + Left Arrow
Filter Pivot TableAlt + Down ArrowOption + Down Arrow
Clear Pivot Table FilterAlt + Shift + Down ArrowOption + Shift + Down Arrow
Expand/Collapse Pivot FieldAlt + Shift + Plus/Minus SignOption + Shift + Plus/Minus Sign
Display Pivot Table Field ListAlt + Shift + F2Option + Shift + F2
Change Summary CalculationAlt + Shift + COption + Shift + C
Open Field SettingsAlt + Shift + OOption + Shift + O
Remove a Field from Pivot TableAlt + Shift + F1Option + Shift + F1
Show/Hide Grand TotalsAlt + Shift + TOption + Shift + T
 
%d