The Ultimate Keyboard Shortcut To A Pivot Table In Excel

What is a pivot table in Excel?

pivot table in Excel allows you to arrange data in various ways with just a few clicks. It automatically analyzes, summarizes, sorts, and filters a huge amount of data.

As well as it calculates the total and average of the data and presents the results in a reasonable manner.

Apart from that, users can easily compare data from different perspectives.

Why use a Pivot Table?

A pivot table in Excel provides various advantages for data analysis, such as:

  • It simplifies a complex set of data.
  • Sort and visualize huge amounts of data in a user-friendly way.
  • It summarizes the data by categories and subcategories.
  • It creates custom reports and improves efficiency in data analysis.
  • Pivoting enables you to rotate rows and columns to visualize different summaries of the presented data.
  • It presents the subtotal and aggregate numerical data in your worksheet.
  • The level of data expands, collapses, and digs down to see the details behind any total.
  • Output concise and engaging online data or printed reports.

Keyboard shortcuts for creating a pivot table in Excel

Creating a pivot table in Excel is a simple process that can be accomplished in just a few clicks.

1. Basic steps in creating a pivot table in Excel

Here are the basic steps:

  1. Select any cells in your current worksheet.
  2. Go to the “Insert tab” in the menu bar.
  3. Click “Tables,” and it will show the list of tables.
  4. Select “From Pivot Table/Range.” A dialog box will pop up.
Basic steps in creating pivot table in Excel

  1. In the “PivotTable from or range,” dialog box you can select the range that you want to use.
  2. And, choose where you want to put your pivot table, either in a new worksheet or an existing one.
Basic steps in creating pivot table in Excel

Note: Don’t forget to check the “Add this data to the Data Model” if you want analyze multiple tables.

  1. Check the data to show in the pivot table layout or drag and drop the fields PivotTable Fields pane.
Basic steps in creating pivot table in Excel

However, we found the two recommended shortcut methods to easily create and open a pivot table in Excel quickly and efficiently:

Using the Recommended PivotTables option allows you to create a pivot table in Excel with just a few clicks. Here’s the following step on how to use it:

  1. Select any cells in your worksheet or the entire range of your data.
  2. Click “Insert” and select “Tables.”
  3. Then, choose the “Recommended PivotTables” option.
Recommended PivotTable Option

  1. Excel will provide you with the recommended pivot table, which you may use; it just depends on your requirements.
Recommended PivotTable Option

  1. This is the result.
Result of using Recommended PivotTable Option

3. Keyboard Shortcut to create a pivot table in Excel

Using the keyboard shortcuts allows you to create pivot tables in Excel quickly and easily.

Here are the following steps on how to use it:

1. Alt + D + P is the shortcut key to open the pivot table in Excel

  1. Select any cells or the entire data set that you want to analyze.
  2. Press the “Alt” + “D” + “P” keys on your keyboard.
  3. After that, it will pop up the pivot table wizard. Kindly refer to the video below:

List of keyboard shortcuts for pivot table

The keyboard shortcuts for pivot tables are invaluable and definitely helpful when you are using pivot tables in Excel.

It would be fun to learn new things, especially in Excel, where it is convenient for you and helps to speed up your work.

Here is the list of pivot table keyboard shortcuts:

PivotTable ShortcutFunction
ALT + D + PTo open pivot table wizard
ALT + N + VUsed to create a pivot table
Ctrl + ATo Select the entire pivot table
F11Used to insert pivot chart to a new Sheet
ALT + F1Used to add a pivot chart to the current worksheet
SpacebarToggle checkboxes in pivot table fields list
ALT + Shift + Left Arrow KeyTo ungroup selected pivot table items
ALT + Shift + Right Arrow KeyTo Group selected pivot table items
ALT + JT +LUsed to view or hide field list
Ctrl + (-) MinusHide item from the pivot table
Alt + F5.Refresh the current pivot table
Ctrl + Alt + F5.Refresh all pivot tables in the workbook

Aside from that, we also have a list of Excel shortcut cheat sheets for more advanced keyboard shortcuts that you may use.


With this tutorial on a shortcut to a pivot table in Excel, you can obtain relevant insights. These insights can speed up your work and improve your data analysis.

These various shortcuts for pivot tables in Excel will definitely help and save you time and effort.

They can be accomplished using the keyboard or the basic option that you discovered above.

We would love to hear some thoughts from you. If you found this tutorial to be a valuable resource, please leave a comment below.

Thank you very much for continuing to read until the end of this article.

Leave a Comment