Shortcut Keys

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

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