Insert pivot table shortcut

• Release Jan 25, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

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.