Shortcuts for pivot table

Pivot Tables Shortcuts

Create pivot table Alt + N, V
Select entire pivot table Ctrl + A
Group pivot table items Alt + Shift + →
Ungroup pivot table items Alt + Shift + ←
Hide (filter out) pivot table item Ctrl + –
Unhide (clear filter out) pivot table item Alt + H, S C
Insert pivot chart Alt + N, S Z C

Priyansh Minocha

Priyansh Minocha is C.E.O and Director at Amonest India Private Limited and Founder at Casolutionsglobal

Leave a Reply