Shortcut Keys

Alt + Shift + Left ArrowUngroup the selected pivot table items.
Alt + Shift + Right ArrowGroup the selected pivot table items.
Ctrl + Shift + 8Select the entire pivot table.
Alt + Down Arrow 
Alt + N, VCreate a pivot table
Alt + LDisplays the pivot table field dialog box
Alt + PMove the selected field to the Page area.
Alt + CMove the selected field to the Column area.
Alt + DMove the selected field to the Data area.
Alt + RMove the selected field to the Row area.
Alt + H, S, CUnhide / clear filter on an item
Alt + N, S, Z, CInserts a pivot chart
Ctrl + ASelect the entire pivot table.
Up Arrow 
Down Arrow 
Left Arrow 
Right Arrow 
Ctrl + -Hide / filter out items

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext