Pivot Table Keyboard Shortcuts

HomePivot TablePivot Table Keyboard Shortcuts

We all love keyboard shortcuts. Right? Here I’ve listed some of the common but useful keyboard shortcuts which you can use to speed up your pivot table work.

1. Create a Pivot Table

Alt + N + V

To use this shortcut key make sure you have selected the source data or the active cell is from the source data. And if you are using the Excel 2007 version then you can use the Alt + N + V + T instead of this.

2. Group/Ungroup Selected Pivot Table Items

Alt + Shift + Right Arrow

Let say you have a pivot table with months and you want to group the first six or last six months. All you need to do it select those six cells and use this shortcut key simply.

Alt + Shift + Left Arrow

Just like you can create a group of items, this shortcut helps you ungroup those items from the group.

3. Hide Selected Item or Field

Ctrl + –

This shortcut key will simply hide the selected cell or cells. Actually, it doesn’t hide the cell but filters them which you can clear after that from the filters options.

4. Open Calculated Field Window

Alt + D and P

In this keyboard shortcut, you need to press the keys subsequently.

5. Open Field List for the Active Cell

Alt + Down Arrow

This key opens the field list.

(Bonus) Insert a Pivot Chart from a Pivot Table

Alt + F1

To use this keyboard shortcut, you need to select a cell from the pivot table. This key inserts a pivot chart into the existing sheet.

More on Pivot Table

Sort a Pivot Table | Refresh a Pivot Table  | Pivot Table Formatting |Move a Pivot Table | Filter a Pivot Table | Count Unique Values in a Pivot Table | Change Pivot Table Data SourceAdd or Remove Grand Total in a Pivot Table | Add Ranks in Pivot Table | Insert Calculation in Pivot Table | Refresh All Pivot Tables  | Automatically Update a Pivot Table | Running Total in a Pivot Table | Conditional Formatting to a Pivot Table | Pivot Table from Multiple Worksheets | Group Dates in a Pivot Table | Connect a Slicer with Multiple Pivot Tables | Pivot Table Timeline