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
- 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
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 in the Help window
- F6
- Switch between the navigation pane and topic pane
- ALT+O
- Display the Options menu to access any Help toolbar command
- ALT+SPACEBAR
- Display the program Control menu
- ALT+F4
- Close the Help window
Keys for working in the navigation pane
- CTRL+TAB
- Switch to the other tab
- ENTER
- Open or close a selected book, or open a selected Help topic
- DOWN ARROW
- Select the next book or Help topic
- UP ARROW
- Select the previous book or Help topic
- SHIFT+F10
- Display shortcut menu
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