Keyboard shortcuts

ALT+DOWN ARROW

Open the list for the currently selected field

The TAB key

Alternately move to the most recently selected item, the OK button, and the Cancel button in the drop-down list for a field

Arrow keys

Move to the next item in the drop-down list for a field

SPACEBAR

Select or clear the check box for the current item in the drop-down list for a field

ENTER

Close the drop-down list for a field and apply any changes you made

ESC

Close the drop-down list for a field without applying your changes

CTRL+L

Display the field list, or activate it if it's already displayed

Arrow keys

Move to the next item in the field list

SHIFT+UP ARROW

Move to the previous item and include it in the selection

SHIFT+DOWN ARROW

Move to the next item and include it in the selection

CTRL+UP ARROW

Move to the previous item, but don't include the item in the selection

CTRL+DOWN ARROW

Move to the next item, but don't include the item in the selection

CTRL+SPACEBAR

Remove the item from the selection, if the item that has focus is included in the selection, and vice versa

PLUS SIGN (numeric keypad)

Expand the current item in the field list to display its contents. Or expand Totals to display the available total fields.

MINUS SIGN (numeric keypad)

Collapse the current item in the field list to hide its contents. Or collapse Totals to hide the available total fields.

The TAB key

Alternately move to the most recently selected item, the Add to button, and the list next to the Add to button in the field list

ALT+DOWN ARROW

Open the drop-down list next to the Add to button in the field list. Use the arrow keys to move to the next item in the list, and then press ENTER to select an item.

ENTER

Add the highlighted field in the field list to the area in the PivotTable list that's displayed in the Add to list

ALT+F4

Close the field list

Keys for working in the Help window

Keys for working in the navigation pane

Keys for working in the topic pane