Select Pivot Table in Excel
Selecting a Pivot Table allows you to quickly work with the entire table, such as formatting, copying, or moving it within your worksheet.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + J + T + Select (or use PivotTable contextual menu) | Ctrl + Shift + * |
What Does This Shortcut Do?
The shortcut selects the entire Pivot Table, including all data, rows, columns, and subtotals, making it easy to perform actions like formatting or moving the table.
How to Use the Shortcut
- Click any cell inside your Pivot Table
- Press the keyboard shortcut:
Windows: Use PivotTable menu shortcuts or Alt + J + T + Select
Mac: Press Ctrl + Shift + * - The entire Pivot Table will be selected
Tips & Best Practices
- Use this shortcut before applying formatting to ensure all parts of the Pivot Table are included
- Useful when copying the Pivot Table to another worksheet
- Combine with keyboard shortcuts for formatting or clearing content
FAQ
- Q: Can I select multiple Pivot Tables at once?
- No, this shortcut only selects the Pivot Table where the active cell is located. You can select multiple tables manually if needed.
- Q: Does it include Pivot Charts?
- No, the shortcut only selects the Pivot Table. Pivot Charts need to be selected separately.
- Q: What if the Pivot Table is filtered?
- All visible data, including filtered rows and columns, will be selected. Hidden rows or columns remain excluded.