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 Moving and Scrolling on Worksheets

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.

 

To perform this action...	Press...
To move one cell up, down, left, or right	Arrow keys
To move one cell to the right	TAB
To move one cell to the left	SHIFT+TAB
To move to the edge of the current data region	CTRL+arrow key
To move to the beginning of the row	HOME
To move to the beginning of the worksheet	CTRL+HOME
To move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column	CTRL+END
To move down one screen	PAGE DOWN
To move up one screen	PAGE UP
To move one screen to the right	ALT+PAGE DOWN
To move one screen to the left	ALT+PAGE UP
To switch to the next pane in a worksheet that has been split (Window menu, Split command)	F6
To switch to the previous pane in a worksheet that has been split	SHIFT+F6
To scroll to display the active cell	CTRL+BACKSPACE
To display the Go To dialog box	F5
To display the Find dialog box	SHIFT+F5
To repeat the last Find action (same as Find Next)	SHIFT+F4
To move between unlocked cells on a protected worksheet	TAB

Moving within Selected Ranges

Note: You can change the direction of movement after pressing ENTER or SHIFT+ENTER: press ALT+T and then O (Tools menu, Options command), press CTRL+TAB until the Edit tab is selected, and then change the Move selection after Enter settings.

Moving and Scrolling in End Mode

END appears in the status bar when End mode is selected.

Moving and Scrolling with SCROLL LOCK On

When you use scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK off, cell selection moves the distance you scroll. To scroll without changing which cells are selected, turn on SCROLL LOCK first.

Go Back to the Top of the Page

[ Home ] [ Keys for General Use ] [ Keys for Moving and Scrolling on a Worksheet ] [ 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 ]