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
The videos below demonstrate this shortcut.
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 create a two-way summary with dynamic array formulas. The result is a summary table that's very similar to a 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 compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
