Key

Description

The TAB key

Move the selection from left to right, and then down

ENTER

Move the selection from top to bottom, and then to the right

SHIFT+TAB

Select the cell to the left. If the current cell is the leftmost cell, SHIFT+TAB selects the last cell in the previous row.

SHIFT+ENTER

Select the cell above the current cell. If the current cell is the topmost cell, SHIFT+ENTER selects the last cell in the previous column.

CTRL+ENTER

Select the detail cells for the next item in the row area

SHIFT+CTRL+ENTER

Select the detail cells for the previous item in the row area

Arrow keys

Move the selection in the direction of the arrow key. If a row or column field is selected, press DOWN ARROW to move to the first item of data in the field, and then press an arrow key to move to the next or previous item or back to the field. If a detail field is selected, press DOWN ARROW or RIGHT ARROW to move to the first cell in the detail area.

SHIFT+arrow key

Extend or reduce the selection in the direction of the arrow key

CTRL+arrow key

Move the selection to the last cell in the direction of the arrow key

SHIFT+ALT+arrow key

Move the selected item in the direction of the arrow key

HOME

Select the leftmost cell of the current row

END

Select the rightmost cell of the current row

CTRL+HOME

Select the leftmost cell of the first row

CTRL+END

Select the last cell of the last row

SHIFT+CTRL+HOME

Extend selection to the leftmost cell of the first row

SHIFT+CTRL+END

Extend selection to the last cell of the last row

CTRL+SPACEBAR

Select the field for the currently selected item of data, total, or detail

SHIFT+SPACEBAR

Select the entire row containing the currently selected cell

CTRL+A

Select the entire PivotTable view

PAGE DOWN

Display the next screen

PAGE UP

Display the previous screen

SHIFT+PAGE DOWN

Extend a selection down one screen

SHIFT+PAGE UP

Reduce a selection by one screen

ALT+PAGE DOWN

Display the next screen to the right

ALT+PAGE UP

Display the previous screen to the left

SHIFT+ALT+PAGE DOWN

Extend selection to the page on the right

SHIFT+ALT+PAGE UP

Extend selection to the page on the left

Key

Description

F1

Display Help topics.

SHIFT+F10

Display the shortcut menu for the selected element of the PivotTable view. Use the shortcut menus to carry out commands in the PivotTable view.

Underlined letter

Carry out a command on the shortcut menu

ESC

Close the shortcut menu without carrying out a command

ALT+ENTER

Display the Properties dialog box

ALT+F4

Close the Properties dialog box

ESC

Cancel a refresh operation in progress

CTRL+C

Copy the selected data from the PivotTable view to the Clipboard

CTRL+E

Export the contents of the PivotTable view to Microsoft Excel

Key

Description

CTRL+8

Show or hide the expand indicators (Plus box and Minus box boxes) beside items

CTRL+PLUS SIGN

Expand the currently selected item

CTRL+MINUS SIGN

Hide the currently selected item

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+T

Turn AutoFilter on or off

CTRL+SHIFT+A

Sort data in the selected field or total in ascending order (A – Z 0 – 9)

CTRL+SHIFT+Z

Sort data in the selected field or total in descending order (Z – A 9 – 0)

ALT+SHIFT+UP ARROW or ALT+SHIFT+LEFT ARROW

Move the selected member up or left

ALT+SHIFT+DOWN ARROW or ALT+SHIFT+RIGHT ARROW

Move the selected member down or right