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 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


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