Keyboard shortcuts in PivotTable lists

Keys for activating, moving around in, and deactivating a PivotTable list

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 select or activate the next control on the Web page

Keys for selecting the elements of a PivotTable list

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

Keys for carrying out commands

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

Keys for displaying, hiding, filtering, and sorting data

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 adding fields and totals, and changing the layout of a PivotTable list

Keys for adding fields and totals

CTRL+SHIFT+S

Add a new total field for the selected field in the PivotTable list by using the Sum summary function

CTRL+SHIFT+C

Add a new total field for the selected field in the PivotTable list by using the Count summary function

CTRL+SHIFT+M

Add a new total field for the selected field in the PivotTable list by using the Min summary function

CTRL+SHIFT+X

Add a new total field for the selected field in the PivotTable list by using the Max summary function

CTRL+SHIFT+E

Add a new total field for the selected field in the PivotTable list by using the Average summary function

CTRL+SHIFT+D

Add a new total field for the selected field in the PivotTable list by using the Standard Deviation summary function

CTRL+SHIFT+T

Add a new total field for the selected field in the PivotTable list by using the Standard Deviation Population summary function

CTRL+SHIFT+V

Add a new total field for the selected field in the PivotTable list by using the Variance summary function

CTRL+SHIFT+R

Add a new total field for the selected field in the PivotTable list by using the Variance Population summary function

CTRL+SHIFT+B

Turn subtotals and grand totals on or off for the selected field in the PivotTable list

CTRL+F

Add a calculated detail field

Keys for changing the layout

CTRL+1

Move the selected field in the PivotTable list to the row area

CTRL+2

Move the selected field in the PivotTable list to the column area

CTRL+3

Move the selected field in the PivotTable list to the filter area

CTRL+4

Move the selected field in the PivotTable list to the detail area

CTRL+LEFT ARROW

Move the selected row or column field in the PivotTable list to a higher level

CTRL+RIGHT ARROW

Move the selected row or column field in the PivotTable list to a lower level

Keys for formatting a PivotTable list

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 element.

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 element of the PivotTable list

CTRL+U

Make text underlined in the selected element of the PivotTable list

CTRL+I

Make text italic in the selected element of the PivotTable list

Keys for following hyperlinks

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

Keys for adding, editing, or deleting data

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

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