Sometimes it’s quicker to use a keyboard shortcut, instead of the mouse, to accomplish a task in Excel. Here are some of the keyboard shortcuts for working with pivot tables in Excel 2007 and Excel 2003.
Excel 2007 Pivot Table Keyboard Shortcuts
| Shortcut | Action |
| 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
| Shortcut | Action |
| 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 |
In Pivot Table Wizard
| Shortcut | Action |
| 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 |
_____________
hi, I want to copy the function from the previous column and apply it to the next. For example, applying the “show as percentage of column total” on large pivot with about 30 columns.
There isn’t a built-in feature or shortcut that will do that, unfortunately.
If you have a copy of my Pivot Power Premium add-in, it has a command that changes all the selected columns to a specific Show Values As setting. http://www.contextures.com/xlPivotPremAddIn.html
Otherwise, you’ll have to change each column individually, or write a macro to change them.
How do I move datas in the pivot table from right to left or vice versa? Is there any keyboard shortcuts for move and place like cut (ctrl c) and paste (ctrl v)? Please advise. Thank you.
Hi
what is the keyboard shortcut to select the Pivot table items only and not the headers