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.