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. |
| 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. |
| 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. |