Enter Data

Press

To

Enter

Complete a cell entry and select the cell below. Alt+Enter Start a new line in the same cell.

Ctrl+Enter

Fill the selected cell range with the current entry.

Shift+Enter

Complete a cell entry and select the previous cell above.

Tab

Complete a cell entry and select the next cell to the right.

Shift+Tab

Complete a cell entry and select the previous cell to the left.

Esc

Cancel a cell entry.

Arrow keys

Move one character up, down, left, or right.

Home

Move to the beginning of the line.

F4 or Ctrl+Y

Repeat the last action.

Ctrl+Shift+F3

Create names from row and column labels.

Ctrl+D

Fill down.

Ctrl+R

Fill to the right.

Ctrl+F3

Define a name.

Ctrl+K

Insert a hyperlink.

Ctrl+; (semicolon)

Enter the date.

Ctrl+Shift+: (colon)

Enter the time.

Alt+Down Arrow ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.