Shortcut Keys
This is a list of all the shortcut keys related to cells and ranges.
| Alt + Enter | Enters a new line (or carriage return) inside a cell. |
| Ctrl + " | Enters the value from the cell directly above into the active cell. |
| Ctrl + ' | Enters the formula from the cell directly above into the active cell. |
| Ctrl + 1 | Displays the Format Cells dialog box. |
| Ctrl + Backspace | Selects the current active cell (scrolling if necessary). |
| Ctrl + Down Arrow | Moves to the last row in the current region. |
| Ctrl + End | Moves to the last "used" cell in the active worksheet. This cell is only updated when the workbook is closed. |
| Ctrl + Enter | Fills the selection with the current value. |
| Ctrl + Home | Moves to the first cell in the active worksheet (i.e. "A1"). |
| Ctrl + Shift + 2 | Enters the value from the cell directly above into the active cell. |
| Ctrl + Shift + 8 | Selects the current region (block of contiguous cells). |
| Ctrl + Shift + End | Extends the selection to the last used cell on the worksheet. |
| Ctrl + Shift + Spacebar | Selects all the objects on the worksheet when an object is selected or selects the whole worksheet. |
| Ctrl + Spacebar | Selects the current column when the active cell is inside a table. When pressed again the entire column is selected. If the selection spans multiple columns all these table columns are selected. |
| Ctrl + C | Copies the current selection to the clipboard. |
| Ctrl + D | Enters the value from the cell directly above into the active cell. |
| Ctrl + R | Enters the value from the cell directly to the left into the active cell. |
| Ctrl + V | Pastes the entry from the clipboard. You can also use Enter to paste the entry. |
| Ctrl + X | Cuts the current selection to the clipboard. |
| End + Home | Moves to the last "used" cell on the active worksheet. This cell is only updated when the workbook is closed. |
| Esc | Cancels the cell entry and restores the original contents. |
| F2 | Edits the active cell, putting the cursor at the end. |
| F4 | Repeats the last action. |
| F8 | Toggles whether to extend a selection with the arrow keys. |
| Shift + Spacebar | Selects the current row. |
| Ctrl + Right Arrow | Moves to the last column in the current region or one word to the right. |
| Ctrl + Left Arrow | Moves to the first column in the current region or one word to the left. |
| Ctrl + Up Arrow | Moves to the first row in the current region. |
| Ctrl + Down Arrow | Moves to the last row in the current region. |
© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited TopPrevNext