Excel like a finance pro.
← The libraryPractice · 2 questions →
Pivot & charts shortcut
Select the entire pivot table
Ctrl + Shift + * on Windows, Ctrl + Shift + * on Mac.
Rarely usedDifficulty 1150 · Proficient
When to use it
Selects the entire pivot table including its report filters, for copying or formatting.
The shape of it
- Windows
Ctrl + Shift + *
- Mac
Ctrl + Shift + *
Worked examples
Select a pivot
Click inside the pivot, Ctrl + Shift + * → The whole pivot is selected
Then copy.
Copy as values
Ctrl + Shift + *, Ctrl + C, Ctrl + Alt + V, V → A static copy of the pivot values
Snapshot.
Delete a pivot
Ctrl + Shift + *, then Delete → The pivot is cleared
Remove it.
Worth knowing
- PivotTable Analyze, Select, Entire PivotTable does the same.
- Enable Selection mode lets you select all cells of one label.
- Copy as values to share without the source.
Where it goes wrong
- Same keys as select current region; inside a pivot the behavior changes.
- Deleting part of a pivot is not allowed; select all.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.