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 |
