Copy, Paste and Edit the Cell Content

The key combinations used to work with cell content are listed below.

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.
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.
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.
CTRL+DELETE In the cell edit mode, deletes all characters from the cursor current position to the end of the word.
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+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.

results matching ""

    No results matching ""