Insert pivot table shortcut
A pivot table is a function to extract necessary information from a large amount of data. Instead of creating a pivot table manually, we will show you how to create and insert a pivot table using access key. Let’s use the access key proactively to speed up your work. However, this method is only available on Windows.
Insert pivot table shortcut
To open the Insert Pivot Table dialog box
Windows
Access Key: Alt + N + V + T
Mac
None
To open the Pivot Table Wizard
Windows
Access Key: Alt + D + P
Mac
None
Open the PivotTable dialog box and insert a pivot table
We will show you how to open the dialog box for inserting a pivot table with access key.
Total Time: 1 minute
Select a cell
Select the top-left cell of the table you want to turn into a pivot table. Press Alt + N + V + T.
Press Enter key
The PivotTable from table or range dialog box will appear. Use the ↑ (Up Arrow key) to select the New Worksheet and press Enter.
Finish inserting pivot table
A pivot table has been inserted.
Open the PivotTable Wizard and insert a pivot table
Select the top-left cell of the table you want to turn into a pivot table. Press Alt + D + P.
The PivotTable and PivotChart Wizard – Step 1 of 3 dialog box will appear.
Press Enter.
The PivotTable and PivotChart Wizard – Step 2 of 3 dialog box will appear.
Press Enter.
The PivotTable and PivotChart Wizard – Step 3 of 3 dialog box will appear.
Use the ↑ (Up Arrow key) to select the New worksheet and press Enter.
A pivot table has been inserted.