In this article I am trying to explain shortcut keys for Pivot Chart view in MS Access
Keys for selecting items in a chart
Key | Description |
RIGHT ARROW | Select the next item in the chart |
LEFT ARROW | Select the previous item in the chart |
DOWN ARROW | Select the next group of items |
UP ARROW | Select the previous group of items |
Keys for working with properties and options
Key | Description |
ALT+ENTER | Display the Properties dialog box |
ALT+F4 | Close the Properties dialog box |
The TAB key | When the Properties dialog box is active, select the next item on the active tab |
RIGHT ARROW | When a tab in the Properties dialog box is active, select the next tab |
LEFT ARROW | When a tab in the Properties dialog box is active, select the previous tab |
DOWN ARROW | Display a list or palette when a button that contains a list or palette is selected |
SHIFT+F10 | Display the shortcut menu |
Underlined letter | Carry out a command on the shortcut menu |
ESC | Close the shortcut menu without carrying out a command |
Keys for working with fields
Key | Description |
ALT+DOWN ARROW | Open the list for the currently selected field |
The TAB key | In the drop-down list for a field, alternately move to the most recently selected item, the OK button, and the Cancel button |
Arrow keys | In the drop-down list for a field, move to the next item |
SPACEBAR | In the drop-down list for a field, select or clear the check box 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 |
Keys for working with the field list
Key | Description |
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 keypad) | Expand the current item in the field list to display its contents, or expand Totals to display the available total fields |
MINUS SIGN (numeric keypad) | Collapse the current item in the field list to hide its contents, or collapse Totals to hide the available total fields. |
The TAB key | In the field list, alternately move to the most recently selected item, the Add to button, and the list next to the Add to button |
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 drop area that's displayed in the Add to list |
ALT+F4 | Close the field list |
Leave Comment