Exceljet

Quick, clean, and to the point

Select entire pivot table

Windows shortcut 
CtrlA
Mac shortcut 
A

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

Tip: How to add unique count to a pivot table
In this video, we'll look at how to get a unique count in a pivot table. Pivot tables are excellent tools for counting and summing data, but you might struggle to get a unique or distinct count, because this feature is hidden in a normal pivot table.
Tip: How to copy a pivot table without the data
When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.