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 |
Go Back to the Top of the Page
|