Keyboard Shortcuts
- 4 minutes to read
The Spreadsheet provides the capability to perform common commands quickly using keyboard shortcuts.
All supported shortcuts are divided into the following groups.
File Operations
| Shortcut | Description |
|---|---|
| CTRL+N | Creates a blank workbook (supported only on the Microsoft Edge browsers). |
| CTRL+O | Invokes the Open dialog box to open a new file. |
| CTRL+S | Saves changes in the current workbook. |
| CTRL+P | Invokes the Print dialog box. |
| CTRL+F | Invokes the Find and Replace dialog (with the Find tab activated). |
| SHIFT+F11 | Inserts a new worksheet in front of the existing worksheet within the current workbook (not supported on the Safari browser). |
Navigation Inside Worksheets
| Shortcut | Description |
|---|---|
| LEFT ARROW KEY | Moves the active cell one cell to the left in a worksheet. |
| RIGHT ARROW KEY | Moves the active cell one cell to the right in a worksheet. |
| UP ARROW KEY | Moves the active cell one cell up in a worksheet. |
| DOWN ARROW KEY | Moves the active cell one cell down in a worksheet. |
| ENTER | Moves the active cell one cell down in a worksheet. |
| SHIFT+ENTER | Moves the active cell one cell up in a worksheet. |
| TAB | Moves the active cell one cell to the right in a worksheet. |
| SHIFT+TAB | Moves the active cell one cell to the left in a worksheet. |
Work with Selection
| Shortcut | Description |
|---|---|
| ENTER | Moves the active cell one cell down in the selection. |
| SHIFT+ENTER | Moves the active cell one cell up in the selection. |
| TAB | Moves the active cell one cell to the right in the selection. |
| SHIFT+TAB | Moves the active cell one cell to the left in the selection. |
| CTRL+A | Selects the entire worksheet or the data region to which the active cell belongs. |
| SHIFT+ARROW KEYS | Extends the selection by one cell in the specified direction. |
Cell Content Editing
Shortcut | Description |
|---|---|
F2 | Turns on the edit mode for the active cell and positions the cursor at the end of the cell’s 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 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’s current position to the start of the next word. |
CTRL+Z | Performs the Undo command to reverse the last action or to delete the last entry you typed. |
Copy/Paste Operations
| Shortcut | Description |
|---|---|
| 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 active cell. |
| CTRL+R | Performs the Fill Right command to copy the contents of the leftmost cell to the active cell. |
Cell Formatting
| Shortcut | Description |
|---|---|
| CTRL+B or CTRL+2 | Applies or removes bold formatting. |
| CTRL+I or CTRL+3 | Applies or removes italic formatting. |
| CTRL+U or CTRL+4 | Applies or removes underlining. |
| CTRL+5 | Applies or removes strikethrough formatting. |
| CTRL+SHIFT+7 | Applies the outline border to the selected cell or cell range. |
| CTRL+SHIFT+1 | Applies the General number format with two decimal places. |
| CTRL+SHIFT+2 | Applies the Time format with the hour and minute, and AM or PM. |
| CTRL+SHIFT+3 | Applies the Date format with the day, month and year. |
| CTRL+SHIFT+4 | Applies the Currency format with two decimal places (negative numbers in parantheses). |
| CTRL+SHIFT+5 | Applies the Percentage format with no decimal places. |
| CTRL+SHIFT+6 | Applies the Scientific number format with two decimal places. |