Home > DeveloperSection > Articles > PivotTable view Shortcut keys for MS Access

PivotTable view Shortcut keys for MS Access


Shortcut Keys Shortcut Keys 
Ratings:
0 Comment(s)
 1711  View(s)
Rate this:

PivotTable view Shortcut keys for MS Access

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

               


Don't want to miss updates? Please click the below button!

Follow MindStick