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 Entering Data
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 complete a cell entry and select the cell below |
ENTER |
|
To start a new line in the same cell |
ALT+ENTER |
|
To fill the selected cell range with the current entry |
CTRL+ENTER |
|
To complete a cell entry and select the previous cell above |
SHIFT+ENTER |
|
To complete a cell entry and select the next cell to the right |
TAB |
|
To complete a cell entry and select the previous cell to the left |
SHIFT+TAB |
|
To cancel a cell entry |
ESC |
|
To move one character up, down, left, or right |
Arrow keys |
|
To move to the beginning of the line |
HOME |
|
To repeat the last action |
F4 or CTRL+Y |
|
To create names from row and column labels |
CTRL+SHIFT+F3 |
|
To fill down |
CTRL+D |
|
To fill to the right |
CTRL+R |
|
To define a name |
CTRL+F3 |
|
To insert a hyperlink |
CTRL+K |
|
To enter the date |
CTRL+; (semicolon) |
|
To enter the time |
CTRL+SHIFT+: (colon) |
|
To display a drop-down list of the values in the current column of a range |
ALT+DOWN ARROW |
|
To undo the last action |
CTRL+Z |
Entering Special Characters
Turn on NUM LOCK and use the numeric key pad for these keystrokes.
|
To perform this action... |
Press... |
|
To enter the cent character ¢ |
ALT+0162 |
|
To enter the pound sterling character £ |
ALT+0163 |
|
To enter the yen symbol ¥ |
ALT+0165 |
|
To enter the euro symbol € |
ALT+0128 |
Entering and Calculating Formulas
|
To perform this action... |
Press... |
|
To start a formula |
= (equal sign) |
|
To move the insertion point into the Formula Bar when editing in a cell is turned off |
F2 |
|
To delete one character to the left in the Formula Bar |
BACKSPACE |
|
To complete a cell entry from the cell or Formula Bar |
ENTER |
|
To enter a formula as an array formula |
CTRL+SHIFT+ENTER |
|
To cancel an entry in the cell or Formula Bar |
ESC |
|
To display the Insert Function dialog box in a formula |
SHIFT+F3 |
|
To display the Function Arguments dialog box when the insertion point is to the right of a function name in a formula |
CTRL+A |
|
To insert the argument names and parentheses when the insertion point is to the right of a function name in a formula |
CTRL+SHIFT+A |
|
To paste a defined name into a formula |
F3 |
|
To insert an AutoSum formula with the SUM function |
ALT+= (equal sign) |
|
To copy the value from the cell above the active cell into the cell or the Formula Bar |
CTRL+SHIFT+" (quotation mark) |
|
To copy a formula from the cell above the active cell into the cell or the Formula Bar |
CTRL+' (apostrophe) |
|
To alternate between displaying cell values and displaying formulas |
CTRL+` (single left quotation mark) |
|
To calculate all
worksheets in all open workbooks |
F9 |
|
To calculate the active worksheet |
SHIFT+F9 |
|
To calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation |
CTRL+ALT+F9 |
|
To recheck dependent formulas and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated |
CTRL+ALT+SHIFT+F9 |
|
To calculate the selected portion of a formula |
F9 (To replace the selected portion with the calculated value, press ENTER or, for array formulas, CTRL+SHIFT+ENTER) |
