Quick, clean, and to the point

Select entire pivot table

Windows shortcut 
Mac shortcut 

This shortcut will select the entire pivot table, excluding report filters.

On Windows, Ctrl Shift * also works to select the entire pivot table

Related videos

The videos below demonstrate this shortcut.
In this video, we compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.
In this video, we'll look at how to get a unique count in a pivot table. This feature is hidden by default in a normal pivot table.
In this video, we'll look at how to copy and paste a pivot table without bringing along the source data.
In this video, we'll look at how to create a two-way summary with dynamic array formulas. The result is a summary table that's very similar to a pivot table.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.