P
Pivot Table
Action | Windows Shortcut | Mac Shortcut |
---|---|---|
Create a Pivot Table | Alt + N, V | Control + Option + P |
Refresh a Pivot Table | Alt + F5 | Command + Option + F5 |
Select Entire Pivot Table | Ctrl + A | Command + A |
Expand/Collapse Field | Alt + Left/Right Arrow | Option + Left/Right Arrow |
Move to Next Pivot Field | Tab | Tab |
Move to Previous Pivot Field | Shift + Tab | Shift + Tab |
Toggle Field List | Ctrl + F1 | Command + Option + F |
Group Items in Pivot Table | Alt + Shift + Right Arrow | Option + Shift + Right Arrow |
Ungroup Items in Pivot Table | Alt + Shift + Left Arrow | Option + Shift + Left Arrow |
Filter Pivot Table | Alt + Down Arrow | Option + Down Arrow |
Clear Pivot Table Filter | Alt + Shift + Down Arrow | Option + Shift + Down Arrow |
Expand/Collapse Pivot Field | Alt + Shift + Plus/Minus Sign | Option + Shift + Plus/Minus Sign |
Display Pivot Table Field List | Alt + Shift + F2 | Option + Shift + F2 |
Change Summary Calculation | Alt + Shift + C | Option + Shift + C |
Open Field Settings | Alt + Shift + O | Option + Shift + O |
Remove a Field from Pivot Table | Alt + Shift + F1 | Option + Shift + F1 |
Show/Hide Grand Totals | Alt + Shift + T | Option + Shift + T |