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
Alt + Shift + Left Arrow
Ungroup the selected pivot table items.
Alt + Shift + Right Arrow
Group the selected pivot table items.
Ctrl + Shift + 8
Select the entire pivot table.
Alt + Down Arrow
Alt + N, V
Create a pivot table
Alt + L
Displays the pivot table field dialog box
Alt + P
Move the selected field to the Page area.
Alt + C
Move the selected field to the Column area.
Alt + D
Move the selected field to the Data area.
Alt + R
Move the selected field to the Row area.
Alt + H, S, C
Unhide / clear filter on an item
Alt + N, S, Z, C
Inserts a pivot chart
Ctrl + A
Select the entire pivot table.
Up Arrow
Down Arrow
Left Arrow
Right Arrow
Ctrl + -
Hide / filter out items

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