Press

To

ENTER

Complete a cell entry and move down in the selection

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 move up in the selection

TAB

Complete a cell entry and move to the right in the selection

SHIFT+TAB

Complete a cell entry and move to the left in the selection

ESC

Cancel a cell entry

BACKSPACE

Delete the character to the left of the insertion point, or delete the selection

DELETE

Delete the character to the right of the insertion point, or delete the selection

CTRL+DELETE

Delete text to the end of the line

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

SHIFT+F2

Edit a cell comment

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