Excel Hack

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 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

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

Finish inserting pivot table

A pivot table has been inserted.

Open the PivotTable Wizard and insert a pivot table

Select a cell and press the access key

Select the top-left cell of the table you want to turn into a pivot table. Press Alt + D + P.

Press Enter

The PivotTable and PivotChart Wizard – Step 1 of 3 dialog box will appear.

Press Enter.

If everything is okay press enter

The PivotTable and PivotChart Wizard – Step 2 of 3 dialog box will appear.

Press Enter.

Select an option and 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 worksheet will be inserted

A pivot table has been inserted.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments