Excel 2003 Shortcut Keys
[Keys for General Use] [Keys for Moving and Scrolling on Worksheets] [Keys for Moving between Worksheet Panes, Worksheets, and Workbooks] [Keys for Entering Data] [Keys for Selecting Data and Cells] [Keys for Editing Data] [Keys for Formatting Data] [Keys for Printing and Previewing Spreadsheet Files] [Keys for Working with Names] [Keys for Working with Databases and Lists] [Keys for Outlining Data] [Keys for Working with Charts] [Keys for Working with PivotTables and PivotCharts] [Keys for Working with Objects]
Keys for Working with Databases and Lists
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.
Using Data Forms
|
To perform this action... |
Press... |
| To move to the same field in the next record | DOWN ARROW |
| To move to the same field in the previous record | UP ARROW |
| To move to each field in the record, then to each command button | TAB and SHIFT+TAB |
| To move to the first field in the next record | ENTER |
| To move to the first field in the previous record | SHIFT+ENTER |
| To move to the same field 10 records forward | PAGE DOWN |
| To start a new, blank record | CTRL+PAGE DOWN |
| To move to the same field 10 records back | PAGE UP |
| To move to the first record | CTRL+PAGE UP |
| To move to the beginning or end of a field | HOME or END |
| To extend selection to the end of a field | SHIFT+END |
| To extend selection to the beginning of a field | SHIFT+HOME |
| To move one character left or right within a field | LEFT ARROW or RIGHT ARROW |
| To select the character to the left within a field | SHIFT+LEFT ARROW |
| To select the character to the right within a field | SHIFT+RIGHT ARROW |
Working with AutoFilter
| To perform this action... | Press... |
| To display the AutoFilter list for the current column in the cell that contains the drop-down arrow | ALT+DOWN ARROW |
| To select the next item in the AutoFilter list | DOWN ARROW |
| To select the previous item in the AutoFilter list | UP ARROW |
| To close the AutoFilter list for the current column | ALT+UP ARROW |
| To select the first item (All) in the AutoFilter list | HOME |
| To select the last item in the AutoFilter list | END |
| To filter the range based on the item selected from the AutoFilter list | ENTER |
