Shortcut

Description

F2

Turns on the edit mode for the active cell and positions the cursor at the end of the cell content.

SHIFT+LEFT ARROW KEY

In the cell edit mode, selects or deselects one character to the left.

SHIFT+RIGHT ARROW KEY

In the cell edit mode, selects or deselects one character to the right.

CTRL+SHIFT+LEFT ARROW KEY

In the cell edit mode, selects or deselects one word to the left.

CTRL+SHIFT+RIGHT ARROW KEY

In the cell edit mode, selects or deselects one word to the right.

SHIFT+HOME

In the cell edit mode, selects from the cursor current position to the beginning of the cell.

SHIFT+END

In the cell edit mode, selects from the cursor current position to the end of the cell.

ALT+ENTER

Starts a new line in the same cell.

CTRL+ENTER

Completes a cell entry and stays in the same cell.

ENTER

Completes a cell entry and selects the cell below.

SHIFT+ENTER

Completes a cell entry and selects the cell above.

TAB

Completes a cell entry and selects the cell to the right.

SHIFT+TAB

Completes a cell entry and selects the cell to the left.

ESC

Cancels an entry in a cell or Formula Bar.

BACKSPACE

In the cell edit mode, deletes a character to the left of the cursor.

DELETE

Removes the cell content without affecting the cell formatting.

In the cell edit mode, deletes a character to the right of the cursor.

CTRL+DELETE

In the cell edit mode, deletes all characters from the cursor current position to the end of the line.

CTRL+Z or ALT+BACKSPACE

Performs the Undo command to reverse the last action or to delete the last entry you typed.

CTRL+Y or ALT+SHIFT+BACKSPACE

Repeats the last action.

CTRL+C or CTRL+INSERT

Copies the selected cell in the clipboard.

CTRL+V or SHIFT+INSERT

Inserts the contents of the clipboard in the specified cell and replaces any selection.

CTRL+ALT+V

Invokes the Paste Special dialog box to specify the paste options.

CTRL+X or SHIFT+DELETE

Cuts the selected cells.

CTRL+D

Performs the Fill Down command to copy the contents of the topmost cell to the cells below.

CTRL+R

Performs the Fill Right command to copy the contents of the leftmost cell to the cell to the right.

CTRL+K

Invokes the Insert Hyperlink dialog box to create a new hyperlink.

SHIFT+F2

Adds a comment to the active cell.