Excel Pivot Table Shortcuts

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 19, 2023

This tutorial will demonstrate how to use shortcuts when working with PivotTables.

PivotTable Shortcuts

PivotTable Shortcuts

What is a PivotTable?

A PivotTable is a great tool that uses a table to summarize and analyze data. This can better understand the data to see trends and comparisons.

The PivotTable below shows the units and sales from 2016 to 2019 by quarter.

 

Sample Pivot Table

What is a Pivot Chart?

pivot chart is the visual representation of a pivot table in Excel.

What is a Pivot Chart

Shortcut to Open Pivot Table Wizard

To open the Pivot Table Wizard use these shortcuts:

PC Shortcut: ALT>N>V
Mac Shortcut:+>P

Open Pivot Table Wizard

Create PivotTable

  1. To create a PivotTable, type Alt > N > VT. This will automatically highlight the table. Press Enter or click OK.

Create PivotTable

This will create a pivot table based on the data that was selected.

Pivot Table Result

Shortcut to Check/Uncheck PivotTable Field Item

A PivotTable Field is used to customize the PivotTable. This lets you select which categories you would like to show.

  1. Scroll up or down to select which Item
  2. Click Space to check or uncheck the item. This will automatically update the Pivot Table.

 

PivotTable Field Options

Shortcut to Select Entire PivotTable

  1. Press a cell inside the PivotTable
  2. Select Ctrl + A

Select Entire PivotTable

Shortcut to Group a PivotTable

  1. Select Item
  2. Press and Hold Alt + Shift + ®
  3. Select your Grouping and Click

Group a PivotTable

Shortcut to Ungroup a Pivot Table

  1. Select Item
  2. Press and Hold Alt + Shift + ¬

Ungroup a Pivot Table

Shortcut to Create a PivotChart on the same worksheet

  1. Click on a cell in the PivotTable
  2. Press and hold Alt + F1

Create a PivotChart

Shortcut to Create a PivotChart on a New Worksheet

  1. Click on a cell in the PivotTable.
  2. Press F11. This will create a chart on another tab in the workbook.

Create a PivotChart on a New Worksheet

AI Formula Generator

Try for Free