O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required