Keyboard shortcuts

For information about activating and deactivating a chart by using the keyboard, see Help for your design program.

Keys for selecting items in a chart

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

Keys for working with commands and options

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

Keys for working with a data sheet

Keys for working with fields

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

Keys for working with the field list

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 with Help

Keys for working in the Help window

Keys for working in the navigation pane

Keys for working in the topic pane

ALT+RIGHT ARROW: Go forward to a Help topic you viewed previously
ALT+LEFT ARROW: Go back to a Help topic you viewed previously
The TAB key: Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic
SHIFT+TAB: Select the previous hidden text or hyperlink
ENTER: Perform the action for the selected Show All, Hide All, hidden text, or hyperlink
UP ARROW or DOWN ARROW: Scroll toward the beginning or end of a Help topic
PAGE UP or PAGE DOWN: Scroll toward the beginning or end of a Help topic in larger increments
HOME or END: Go to the beginning or end of a Help topic
CTRL+P: Print the current Help topic
CTRL+A: Select the entire Help topic
CTRL+C: Copy selection to the Clipboard
SHIFT+F10: Display shortcut menu