- 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.
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 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 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
Note The following four shortcuts do not work if you press the keys 1, 2, 3, or 4 from the numeric pad of your keyboard.
- 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 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
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 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