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 Editing 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 edit the active cell |
F2 |
|
To accept edits |
ENTER |
|
To cancel edits |
ESC |
Navigating Cell Entries
|
To perform this action... |
Press... |
|
To move one character up, down, left, or right |
UP, DOWN, LEFT, or RIGHT ARROW |
|
To move to the beginning of the line |
HOME |
| To move to the end of the line | END |
|
To move to the beginning of the entry |
CTRL+HOME |
| To move to the end of the entry | CTRL+END |
| To move one group of characters to the left or right | CTRL+LEFT or RIGHT ARROW |
Editing Cell Entries
|
To perform this action... |
Press... |
|
To edit the active cell and position the insertion point at the end of the cell contents |
F2 |
|
To edit a cell comment |
SHIFT+F2 |
|
To start a new line in the same cell |
ALT+ENTER |
|
To edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents |
BACKSPACE |
|
To delete the character to the right of the insertion point, or delete the selection |
DELETE |
|
To delete text to the end of the line |
CTRL+DELETE |
|
To complete a cell entry and select the next cell below |
ENTER |
|
To cancel a cell entry |
ESC |
|
To display the Spelling dialog box |
F7 |
|
To undo the last action |
CTRL+Z |
|
To undo or redo the last automatic correction when the AutoCorrect Smart Tag is displayed |
CTRL+SHIFT+Z |
Inserting, Deleting, Cutting, and Copying Selections
|
To perform this action... |
Press... |
|
To copy the selected cells |
CTRL+C |
|
To display the Microsoft Office Clipboard (multiple copy and paste) |
CTRL+C, immediately followed by another CTRL+C |
|
To cut the selected cells |
CTRL+X |
|
To paste copied cells |
CTRL+V |
|
To clear the contents of the selected cells |
DELETE |
|
To delete the selected cells |
CTRL+HYPHEN |
|
To insert blank cells |
CTRL+SHIFT+PLUS SIGN |
