In this article I am trying to explain PivotTable view Shortcut keys for MS Access.
Keys for selecting elements in PivotTable view
Key | Description | |
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+ENTER | Select the detail cells for the next item in the row 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 is selected, press DOWN ARROW or RIGHT ARROW to move to the first cell in the detail 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 view |
|
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 |
|
ALT+PAGE DOWN | Display the next screen to the right |
|
ALT+PAGE UP | Display the previous screen to the left |
|
SHIFT+ALT+PAGE DOWN | Extend selection to the page on the right |
|
SHIFT+ALT+PAGE UP | Extend selection to the page on the left |
|
Keys for carrying out commands
Key | Description |
F1 | Display Help topics. |
SHIFT+F10 | Display the shortcut menu for the selected element of the PivotTable view. Use the shortcut menus to carry out commands in the PivotTable view. |
Underlined letter | Carry out a command on the shortcut menu |
ESC | Close the shortcut menu without carrying out a command |
ALT+ENTER | Display the Properties dialog box |
ALT+F4 | Close the Properties dialog box |
ESC | Cancel a refresh operation in progress |
CTRL+C | Copy the selected data from the PivotTable view to the Clipboard |
CTRL+E | Export the contents of the PivotTable view to Microsoft Excel |
Keys for displaying, hiding, filtering, or sorting data
Key | Description |
CTRL+8 | Show or hide the expand indicators (Plus box and Minus box boxes) beside items |
CTRL+PLUS SIGN | Expand the currently selected item |
CTRL+MINUS SIGN | 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 |
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 |
Samuel Fernandes
30-Jul-2017Keep sharing these types of articles.
It was really helpful to read this post.