Keyboard shortcuts

RIGHT ARROW

Select the next item in the chart

LEFT ARROW

Select the previous item in the chart

DOWN ARROW

Select the next group of items

UP ARROW

Select the previous group of items

ALT+ENTER

Display the Commands and Options dialog box

ALT+F4

Close the Commands and Options dialog box

The TAB key

When the Commands and Options dialog box is active, select the next item on the active tab

Right Arrow

When a tab in the Commands and Options dialog box is active, select next tab

Left arrow

When a tab in the Commands and Options dialog box is active, select previous tab

Down arrow

Display a list or palette when button that contains a list or palette is selected

SHIFT+F10

Display the shortcut menu

Underlined letter

Carry out a command on the shortcut menu

ESC

Close the shortcut menu without carrying out a command

CTRL+Z

Undo an action in the chart

DELETE

Delete the currently selected item

ENTER

Enter data, and move cell selection down one cell

The TAB key

Enter data, and move cell selection one to the right

Arrow keys

Move one cell to the left, right, up or down

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 pad)

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

MINUS SIGN (numeric pad)

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