Copy, Paste and Edit the Cell Content
- 3 minutes to read
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. |
CTRL+ENTER | Completes a cell entry and stays in the same cell. |
ENTER | Completes a cell entry and selects the cell below. To change this default behavior, use the SpreadsheetSelectionBehaviorOptions.MoveActiveCellMode property. |
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. |