Excel Pivot Table Hotkeys

Hotkeys are essential to learn as they can significantly increase the speed of working in Excel. Arguably, some are used much more often than others. The most important hotkeys to learn for Microsoft Excel Pivot tables are listed below.

Ctrl>arrow keys

Ctrl>shift>arrow keys

This set of hotkeys allows for your selected cell to jump around as needed. Holding down shift while doing this will allow one to quickly select data as needed.

Alt>A>C

This is a quick way to clear filters in any aspect of Excel. A good way to remember this hotkey if you are a beginner is to use an acronym. A classic acronym for this hotkey is “All Clear” because it used both the letters and has the details of the result included.

Alt>D>P

This is the hotkey to open up a Pivot Table in Microsoft Excel. An acronym for this one is “Data Pivot” since it includes what it used for and the result.

Alt>D>P

This is the hotkey to open up a Pivot Table in Microsoft Excel. An acronym for this one is “Data Pivot” since it includes what it used for and the result.

Spacebar

This is primarily used within an open filter to quickly select and deselect items needed. Note that arrow keys can also be used within the filter setting to navigate quickly.

Ctrl>Spacebar

Ctrl>Spacebar selected the entire column of data based on where the currently selected cell is.

Selecting the entire column of data.

Shift>Spacebar

Shift>Spacebar selects the entire row of data based on where the currently selected cell is.

Selecting the entire row of data.

summary