Excel Pivot Table Keyboard Shortcuts Cheat Sheet |
Overview - it’s quicker to use a keyboard shortcut in Excel Pivot Tables to complete certain tasks. The Cheat Sheet list below shows some of the keyboard shortcuts for working with Excel pivot tables in Excel 2007 and Excel 2003
Excel 2003 Pivot Table Keyboard Shortcuts
|
Keyboard Shortcut |
Shortcut Description |
|
Ctrl + Shift + * |
Select entire pivot table (not including Report Filters) |
|
Ctrl + A |
Select entire pivot table (not including Report Filters) |
| >
Spacebar |
Add or remove checkmark for selected field in PivotTable Field List |
|
Alt + Shift + Right Arrow |
Group selected pivot table items |
|
Alt + Shift + Left Arrow |
Ungroup selected pivot table items |
|
Down Arrow |
Select next item in PivotTable Field List or Items List |
|
Up Arrow |
Select previous item in PivotTable Field List or Items List |
|
End |
Select last item in PivotTable Field List or Items List |
|
Home |
Select first item in PivotTable Field List or Items List |
|
Alt + Down Arrow |
Open field list for active cell |
|
Ctrl + - |
Hide selected item or field |
|
Shift + Ctrl + = |
When data field selected, opens Calculated Field dialog box |
|
Shift + Ctrl + = |
When field heading cell selected, opens Calculated Item dialog box |
|
Alt + D, P |
Open the old PivotTable Wizard |
Excel 2003 Pivot Table Keyboard Shortcuts
In Pivot Table
|
Keyboard Shortcut> |
Shortcut Description |
|
Alt + L |
Show Pivot Table dialog box |
|
Alt + R |
move selected field into Row area |
Alt + D |
move selected field into Data area |
|
Shift + Right Arrow |
Group selected pivot table items |
Alt + Shift + Left Arrow |
Ungroup selected pivot table items |
|
Down Arrow |
Select next item in Items List |
|
Up Arrow |
Select previous item in Items List |
|
End |
Select last visible item in List |
|
Home |
Select first visible item in List |
|
Alt + Down Arrow |
Open field list for active cell |
|
Ctrl + - |
Hide selected item or field |
|
Shift + Ctrl + = |
When data field selected, opens Calculated Field dialog box |
|
Shift + Ctrl + = |
When field heading cell selected, opens Calculated Item dialog box |
Excel 2003 Pivot Table Keyboard Shortcuts
In Pivot Table Wizard
|
Keyboard Shortcut |
Shortcut Description |
|
Alt + C |
move selected field into Column area |
|
Alt + R |
move selected field into Row area |
|
Alt + D |
move selected field into Data area |
|
Alt + P |
move selected field into Page area |
| Excel Home | Excel Pivot Tables :: Organise Your Source Data |