Pivot Tables – Microsoft Excel Shortcuts | GoSkills

200 Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we've curated 200 of the best Excel keyboard shortcuts.

Learn Microsoft Excel Download PDF

Table of contents

Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to Cells

Pivot Tables

Pivot tables allow you to extract information and significance from massive sets of data within Excel. Although operating within them can be difficult, using these shortcuts to navigate within them and control data points can turn even novices in pivot table aficionados.

To do this

Windows keys

Mac keys

Select entire pivot table

Ctrl A

⌘ A

Toggle pivot table checkbox

Space

Space

Group pivot table items

Alt Shift →

⌘ Shift K

Ungroup pivot table items

Alt Shift ←

⌘ Shift J

Add pivot chart to current worksheet

Alt F1

N/A

Add pivot chart to new worksheet

F11

Fn F11

Hide item from pivot table

Ctrl -

Ctrl -

Launch pivot table wizard

Alt D P

⌘ Option P

Worksheets and Workbooks

View

Row and Column Selection

Ribbon Control

Pivot Tables

Pivot tables allow you to extract information and significance from massive sets of data within Excel. Although operating within them can be difficult, using these shortcuts to navigate within them and control data points can turn even novices in pivot table aficionados.

Select entire pivot table

Toggle pivot table checkbox

Group pivot table items

Alt Shift →

⌘ Shift K

Ungroup pivot table items

Alt Shift ←

⌘ Shift J

Add pivot chart to current worksheet

Add pivot chart to new worksheet

Hide item from pivot table

Launch pivot table wizard

⌘ Option P

Operating within a Cell

Navigating and Selecting Cells

Help and Menus

Group Selection

General Excel

General Cell Control

Formulas and Functions

Formatting Text and Numbers

Dialog Boxes

Borders

Advanced Selection

Adding Content to Cells

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.