Home Up Bookstore Site Map Site Search

Access 2003 Shortcut Keys

[Keys for General Use] [Keys for Use in the Database Window] [Keys for Navigating Records] [Keys for Selecting Text or Data] [Keys for Editing Text or Data] [Keys for Working in Print Preview and Layout Preview] [Keys for Working in the Query Designer in an Access Project] [Keys for Working with PivotTable and PivotChart Views]


Keys for Working with PivotTable and PivotChart Views

All shortcut keys are based on the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard.

For keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign, like this: SHIFT+F10.
For shortcuts in which you press keys one after the other, the keys to press are separated by a comma, like this: ALT, F, X.

[Working with PivotTable View] [Working with PivotChart View]

Working with PivotTable View

Selecting Elements in PivotTable View

To perform this action...

Press...

To move the selection from left to right, and then down

The TAB key

To move the selection from top to bottom, and then to the right

ENTER

To select the cell to the left

SHIFT+TAB (selects the last cell in the previous row if the current cell is the leftmost)

To select the cell above the current cell

SHIFT+ENTER (selects the last cell in the previous column if the current cell is the topmost)

To select the detail cells for the next item in the row area

CTRL+ENTER

To select the detail cells for the previous item in the row area

SHIFT+CTRL+ENTER

To move the selection in the direction of the arrow key

Arrow keys (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.)

To extend or reduce the selection in the direction of the arrow key

SHIFT+arrow key

To move the selection to the last cell in the direction of the arrow key

CTRL+arrow key

To move the selected item in the direction of the arrow key

SHIFT+ALT+arrow key

To select the leftmost cell of the current row

HOME

To select the rightmost cell of the current row

END

To select the leftmost cell of the first row

CTRL+HOME

To select the last cell of the last row

CTRL+END

To extend selection to the leftmost cell of the first row

SHIFT+CTRL+HOME

To extend selection to the last cell of the last row

SHIFT+CTRL+END

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

CTRL+SPACEBAR

To select the entire row containing the currently selected cell

SHIFT+SPACEBAR

To select the entire PivotTable view.

CTRL+A

To display the next screen

PAGE DOWN

To display the previous screen

PAGE UP

To extend a selection down one screen

SHIFT+PAGE DOWN

To reduce a selection by one screen

SHIFT+PAGE UP

To display the next screen to the right

ALT+PAGE DOWN

To display the previous screen to the left

ALT+PAGE UP

To extend selection to the page on the right

SHIFT+ALT+PAGE DOWN

To extend selection to the page on the left

SHIFT+ALT+PAGE UP

Executing Commands

To perform this action...

Press...

To display Help topics

F1

To display the shortcut menu for the selected element of the PivotTable view

SHIFT+F10

To carry out a command on the shortcut menu

Underlined letter

To close the shortcut menu without carrying out a command

ESC

To display the Properties dialog box

ALT+ENTER

To close the Properties dialog box

ALT+F4

To cancel a refresh operation in progress

ESC

To copy the selected data from the PivotTable view to the Clipboard

CTRL+C

To export the contents of the PivotTable view to Microsoft Excel

CTRL+E

Displaying, Hiding, Filtering, and Sorting Data

To perform this action...

Press...

To show or hide the expand indicators (plus and minus boxes) beside items

CTRL+8

To expand the currently selected item

CTRL+PLUS SIGN

To hide the currently selected item

CTRL+MINUS SIGN

To open the list for the currently selected field

ALT+DOWN ARROW

To move to the most recently selected item, the OK button, and the Cancel button in the drop-down list for a field

The TAB key

To move to the next item in the drop-down list for a field

Arrow keys

To select or clear the check box for the current item in the drop-down list for a field

SPACEBAR

To close the drop-down list for a field and apply any changes you made

ENTER

To close the drop-down list for a field without applying your changes

ESC

To turn AutoFilter on or off

CTRL+T

To sort data in the selected field or total in ascending order (A � Z, 0 � 9)

CTRL+SHIFT+A

To sort data in the selected field or total in descending order (Z � A, 9 � 0)

CTRL+SHIFT+Z

To move the selected member up or left

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

To move the selected member down or right

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

Adding Fields and Totals and Changing the Layout of a PivotTable View
Working with the Field List

To perform this action...

Press...

To display the field list, or activate it if it's already displayed

CTRL+L

To move to the next item in the field list

Arrow keys

To move to the previous item and include it in the selection

SHIFT+UP ARROW

To move to the next item and include it in the selection

SHIFT+DOWN ARROW

To move to the previous item, but don't include the item in the selection

CTRL+UP ARROW

To move to the next item, but don't include the item in the selection

CTRL+DOWN ARROW

To remove the item from the selection, if the item that has focus is included in the selection, and vice versa

CTRL+SPACEBAR

To expand the current item in the field list to display its contents, or expand Totals to display the available total fields

PLUS SIGN (numeric keypad)

To collapse the current item in the field list to hide its contents, or collapse Totals to hide the available total fields.

MINUS SIGN (numeric keypad)

To move to the most recently selected item, the Add to button, and the list next to the Add to button in the field list

The TAB key

To open the drop-down list next to the Add to button in the field list

ALT+DOWN ARROW, then the arrow keys to move to the next item in the list. Press ENTER to select an item.

To add the highlighted field in the field list to the area in the PivotTable view that's displayed in the Add to list

ENTER

To close the field list

ALT+F4

Adding Fields and Totals

To perform this action...

Press...

To add a new total field for the selected field in the PivotTable view by using the Sum summary function

CTRL+SHIFT+S

To add a new total field for the selected field in the PivotTable view by using the Count summary function

CTRL+SHIFT+C

To add a new total field for the selected field in the PivotTable view by using the Min summary function

CTRL+SHIFT+M

To add a new total field for the selected field in the PivotTable view by using the Max summary function

CTRL+SHIFT+X

To add a new total field for the selected field in the PivotTable view by using the Average summary function

CTRL+SHIFT+E

To add a new total field for the selected field in the PivotTable view by using the Standard Deviation summary function

CTRL+SHIFT+D

To add a new total field for the selected field in the PivotTable view by using the Standard Deviation Population summary function

CTRL+SHIFT+T

To add a new total field for the selected field in the PivotTable view by using the Variance summary function

CTRL+SHIFT+V

To add a new total field for the selected field in the PivotTable view by using the Variance Population summary function

CTRL+SHIFT+R

To turn subtotals and grand totals on or off for the selected field in the PivotTable view

CTRL+SHIFT+B

To add a calculated detail field

CTRL+F

Changing the Layout

To perform this action...

Press...

To move the selected field in the PivotTable view to the row area

CTRL+1 (don't use the numeric pad on your keyboard)

To move the selected field in the PivotTable view to the column area

CTRL+2 (don't use the numeric pad on your keyboard)

To move the selected field in the PivotTable view to the filter area

CTRL+3 (don't use the numeric pad on your keyboard)

To move the selected field in the PivotTable view to the detail area

CTRL+4 (don't use the numeric pad on your keyboard)

To move the selected row or column field in the PivotTable view to a higher level

CTRL+LEFT ARROW

To move the selected row or column field in the PivotTable view to a lower level

CTRL+RIGHT ARROW

Formatting Elements in PivotTable View

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.

To perform this action...

Press...

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

CTRL+SHIFT+~ (tilde)

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

CTRL+SHIFT+$

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

CTRL+SHIFT+%

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

CTRL+SHIFT+^

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

CTRL+SHIFT+#

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

CTRL+SHIFT+@

To 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+SHIFT+!

To make text bold in the selected field of the PivotTable view.

CTRL+B

To make text underlined in the selected field of the PivotTable view

CTRL+U

To make text italic in the selected field of the PivotTable view

CTRL+I

Go Back to the Top of the Page

Working with PivotChart View

Selecting Items in Charts

To perform this action...

Press...

To select the next item in the chart

RIGHT ARROW

To select the previous item in the chart

LEFT ARROW

To select the next group of items

DOWN ARROW

To select the previous group of items

UP ARROW

Working with Properties and Options

To perform this action...

Press...

To display the Properties dialog box

ALT+ENTER

To close the Properties dialog box

ALT+F4

To select the next item on the active tab when the Properties dialog box is active

The TAB key

To select the next tab when a tab in the Properties dialog box is active

RIGHT ARROW

To select the previous tab when a tab in the Properties dialog box is active

LEFT ARROW

To display a list or palette when a button that contains a list or palette is selected

DOWN ARROW

To display the shortcut menu

SHIFT+F10

To carry out a command on the shortcut menu

Underlined letter

To close the shortcut menu without carrying out a command

ESC

Working with Fields

To perform this action...

Press...

To open the list for the currently selected field

ALT+DOWN ARROW

To move to the most recently selected item, the OK button, and the Cancel button in the drop-down list for a field

The TAB key

To move to the next item in the drop-down list for a field

Arrow keys

To select or clear the check box for the current item in the drop-down list for a field

SPACEBAR

To close the drop-down list for a field and apply any changes you made

ENTER

To close the drop-down list for a field without applying your changes

ESC

Working with the Field List

To perform this action...

Press...

To display the field list, or activate it if it's already displayed

CTRL+L

To move to the next item in the field list

Arrow keys

To move to the previous item and include it in the selection

SHIFT+UP ARROW

To move to the next item and include it in the selection

SHIFT+DOWN ARROW

To move to the previous item, but don't include the item in the selection

CTRL+UP ARROW

To move to the next item, but don't include the item in the selection

CTRL+DOWN ARROW

To remove the item from the selection if the item that has focus is included in the selection, and vice versa

CTRL+SPACEBAR

To expand the current item in the field list to display its contents, or expand Totals to display the available total fields

PLUS SIGN (on the numeric keypad)

To collapse the current item in the field list to hide its contents, or collapse Totals to hide the available total fields.

MINUS SIGN (on the numeric keypad)

To move to the most recently selected item, the Add to button, and the list next to the Add to button in the field list

The TAB key

To open the drop-down list next to the Add to button in the field list

ALT+DOWN ARROW (use the arrow keys to move to the next item in the list; press ENTER to select the item)

To add the highlighted field in the field list to the drop area that's displayed in the Add to list

ENTER

To close the field list

ALT+F4

Go Back to the Top of the Page


Home ] Keys for General Use ] Keys for Use in the Database Window ] Keys for Navigating Records ] Keys for Selecting Text or Data ] Keys for Editing Text or Data ] Keys for Working in Print Preview and Layout Preview ] Keys for Working in the Query Designer in an Access Project ] [ Keys for Working with PivotTable and PivotChart Views ]

Send mail with questions or comments about this web site to our webmaster.
Last modified: June 05, 2004

Labelled with ICRA