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. You will see the text "Extend Selection" appear in the status bar. |
| Shift + F8 | Toggles between switching Add Mode on or off. This allows you to select non contiguous blocks of cells using the keyboard arrow keys. You will see the text "Add to Selection" appear in the status bar. |
| 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. |
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext