Keyboard shortcuts in PivotTable lists

The TAB key

Select or activate each control on a Web page in sequence. After you activate a PivotTable list, pressing the TAB key selects elements within the PivotTable list.

CTRL+TAB

Deactivate (or exit) a PivotTable list and move focus to the Address box on the browser.

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

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

CTRL+ENTER

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

SHIFT+CTRL+TAB

Select the detail cells for the previous item in the column 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 or an item of data is selected, press DOWN ARROW or RIGHT ARROW to move to the first cell in the detail area or data 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 list

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

SHIFT+F10

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

Underlined letter

Carry out a command on the shortcut menu

ESC

Close the shortcut menu without carrying out a command

CTRL+7

Display or hide the PivotTable list toolbar

ALT+ENTER

Display the Commands and Options dialog box

ALT+F4

Close the Commands and Options dialog box

F9

Refresh the PivotTable list from the source data

ESC

Cancel a refresh operation in progress

CTRL+C

Copy the selected data from the PivotTable list to the Clipboard

CTRL+V

Paste contents of the Clipboard

CTRL+X

Move selected data to the Clipboard

CTRL+E

Export the PivotTable list to Microsoft Excel

CTRL+8

Display or hide the expand indicators ( and boxes) beside items

CTRL+PLUS SIGN (numeric pad)

Expand the currently selected item

CTRL+MINUS SIGN (numeric pad)

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

CTRL+>

Display detail, if available, for the current item

CTRL+<

Hide detail for the current item

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

Keys for working with the field list

Keys for adding fields and totals

Keys for changing the layout

To use the following shortcuts, first select a detail field or a data cell for a total field.

The first seven keyboard shortcuts change the number format of the selected field.

CTRL+SHIFT+~ (tilde)

Apply the general number format to values in the selected total or detail field

CTRL+SHIFT+$

Apply the currency format, with two decimal places and negative numbers in parentheses, to values in the selected total or detail field

CTRL+SHIFT+%

Apply the percentage format, with no decimal places, to values in the selected total or detail field

CTRL+SHIFT+^

Apply the exponential number format, with two decimal places, to values in the selected total or detail field

CTRL+SHIFT+#

Apply the date format, with the day, month, and year, to values in the selected total or detail field

CTRL+SHIFT+@

Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field

CTRL+SHIFT+!

Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field

CTRL+B

Make text bold in the selected field of the PivotTable list

CTRL+U

Make text underlined in the selected field of the PivotTable list

CTRL+I

Make text italic in the selected field of the PivotTable list

To use the following shortcuts, first select the hyperlink cell or item.

ENTER

Follow the hyperlink

SHIFT+ENTER

Open the link in a new window

F2

Enter edit mode

The TAB key

Accept edit, move focus right, and then move focus down

ENTER

Accept edit, move focus down, and then move focus right

SHIFT+TAB

Accept edit, move focus left, and then move focus up

SHIFT+ENTER

Accept edit, move focus up, and then move focus left

ESC

Discard edit

DELETE

Delete all selected rows

Keys for working in the Help window

Keys for working in the navigation pane

Keys for working in the topic pane