Home Up Bookstore Site Map Site Search

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)

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 ]

Send mail with questions or comments about this web site to our webmaster.
Last modified: June 05, 2004

Labelled with ICRA