aspnet-117687-components-spreadsheet-keyboard-shortcuts.md
The Spreadsheet provides the capability to perform common commands quickly using keyboard shortcuts.
All supported shortcuts are divided into the following groups.
| 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). |
| 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. |
| 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. |
|
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.
|
| 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. |
| 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. |