Excel Pivot Table Keyboard Shortcuts
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 2003 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 |
_____________
iCloud, a new music service from Apple is expected to be unveiled today. According to soures Apple CEO Steve Jobs is returning brielfy from his medical leave to introduce the latest service. The difference between iCloud and other music services is that it allows music and other information on the internet to be store withoutiphone 5.