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

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Excel Shortcut Select entire pivot table - 76Excel Shortcut Select entire pivot table - 39Excel Shortcut Select entire pivot table - 22Excel Shortcut Select entire pivot table - 17Excel Shortcut Select entire pivot table - 33