Universal Design SymbolWork with databases, lists, and PivotTables by using shortcut keys:

The following five tables give keyboard commands available in Microsoft Excel for:

  1. working in a data form
  2. working with the AutoFilter feature
  3. working with the PivotTable Wizard
  4. working with page fields in a PivotTable
  5. grouping and ungrouping PivotTable items

In each table, the left column gives the desired action and the right column gives the associated keyboard shortcut.

1. Working in a data form

Desired Action Keyboard Shortcut
Select a field or a command button. ALT+leter, where letter is the underlined letter in the field or command name
Move to the same field in the next record. DOWN ARROW
Move to the same field in the previous record. UP ARROW
Move to the next field you can edit in the record. TAB
Move to the previous field you can edit in the record. SHIFT+TAB
Move to the first field in the next record. ENTER
Move to the first field in the previous record. SHIFT+ENTER
Move to the same field 10 records forward. PAGE DOWN
Move to the same field 10 records back. PAGE UP
Move to the new record. CONTROL+PAGE DOWN
Move to the first record. CONTROL+PAGE UP
Move to the beginning or end of a field. HOME or END
Move one character left or right within a field. LEFT ARROW or RIGHT ARROW
Extend a selection to the beginning of a field. SHIFT+HOME
Extend a selection to the end of a field. SHIFT+END
Select the character to the left. SHIFT+LEFT ARROW
Select the character to the right. SHIFT+RIGHT ARROW

2. Working with the AutoFilter feature

Desired Action Keyboard Shortcut
Display the AutoFilter list for the current column. Select the cell that contains the column label, and then press ALT+DOWN ARROW
Close the AutoFilter list for the current column. ALT+UP ARROW
Select the next item in the AutoFilter list. DOWN ARROW
Select the previous item in the AutoFilter list. UP ARROW
Select the first item (All) in the AutoFilter list. HOME
Select the last item in the AutoFilter list. END
Filter the list by using the selected item in the AutoFilter list. ENTER

3. Working with the PivotTable Wizard (Step 3)

Desired Action Keyboard Shortcut
Select the next or previous field button in the list. UP ARROW or DOWN ARROW
Select the field button to the right or left in a multicolumn field button list. LEFT ARROW or RIGHT ARROW
Move the selected field into the Page area. ALT+P
Move the selected field into the Row area. ALT+R
Move the selected field into the Column area. ALT+C
Move the selected field into the Data area. ALT+D
Display the PivotTable Field dialog box. ALT+L

4. Working with page fields in a PivotTable

Desired Action Keyboard Shortcut
Select the previous item in the list. UP ARROW
Select the next item in the list. DOWN ARROW
Select the first visible item in the list. HOME
Select the last visible item in the list. END
Display the selected item. ENTER

5. Grouping and ungrouping PivotTable items

Desired Action Keyboard Shortcut
Group selected PivotTable items. ALT+SHIFT+RIGHT ARROW
Ungroup selected PivotTable items. ALT+SHIFT+LEFT ARROW

Contact us at infotechaccess@server.rehab.uiuic.edu

back to Excel 97 Shortcut keys