Keyboard Shortcuts and Navigation in ASP.NET MVC Spreadsheet Control
28 Jul 202615 minutes to read
The following keyboard shortcuts are supported in the Spreadsheet:
Keyboard shortcut behavior can vary depending on the operating system and browser. On macOS, some
Ctrlshortcuts may use theCommandkey. Browser-reserved shortcuts may override the corresponding Spreadsheet shortcuts.
File operations
| Shortcut | Description |
|---|---|
| Ctrl + O | Displays a dialog to open a file. |
| Ctrl + S / Alt + F2 | Saves the workbook. |
| Ctrl + P | Prints the active worksheet when the spreadsheet is in focus. |
| Ctrl + Alt + N | Opens a new workbook. |
| Shift + F11 | Adds a new worksheet. |
Clipboard and general operations
| Shortcut | Description |
|---|---|
| Ctrl + C | Copies the selected cells. |
| Ctrl + X | Cuts the selected cells. |
| Ctrl + V | Pastes the clipboard content into the selected range. |
| Ctrl + Z | Reverses the last action. |
| Ctrl + Y | Repeats the last reversed action. |
| Ctrl + K | Opens the Insert Hyperlink dialog to add a new hyperlink to a cell. If the selected cell already contains a hyperlink, opens the Edit Hyperlink dialog. |
| Ctrl + F / Shift + F5 | Opens the Find dialog. |
| Ctrl + H | Opens the Find and Replace dialog. |
| Ctrl + G | Opens the Go To dialog to navigate to a cell. |
| Ctrl + Shift + L | Applies a filter to the first row of the selected range or used range. |
| Shift + F10 | Opens the context menu. |
| Shift + F3 | Opens the Insert Function dialog. |
| Ctrl + Shift + F2 | Opens the comment editor for the active cell. Press Esc to close the comment editor. |
| Shift + F2 | Opens the dialog to add or edit a note. Press Esc while the dialog is focused to save the note and close the dialog. |
Cell editing
| Shortcut | Description |
|---|---|
| F2 | Enables edit mode. |
| Esc | Cancels edit mode and discards the changes. |
| Backspace or Space | Clears the active cell content and enters edit mode. |
| Delete | Removes the contents of the active cell. |
| Alt + Enter | Adds a new line while editing a cell. |
| Enter | Completes cell editing and selects the cell below in the same column. |
| Shift + Enter | Completes cell editing and selects the cell above in the same column. |
| Tab | Completes cell editing and selects the next cell in the same row. |
| Shift + Tab | Completes cell editing and selects the previous cell in the same row. |
Cell navigation
| Shortcut | Description |
|---|---|
| Up arrow | Navigates from the active cell to the previous cell in the same column. |
| Down arrow | Navigates from the active cell to the next cell in the same column. |
| Left arrow | Navigates from the active cell to the previous cell in the same row. |
| Right arrow | Navigates from the active cell to the next cell in the same row. |
| Tab | Navigates from the active cell to the next cell in the same row. |
| Shift + Tab | Navigates from the active cell to the previous cell in the same row. |
| Enter | Navigates from the active cell to the next cell in the same column. |
| Shift + Enter | Navigates from the active cell to the previous cell in the same column. |
| Home | Moves the selection to the first column in the worksheet. |
| Ctrl + Home | Moves the selection to the first visible cell in the worksheet. |
| Ctrl + Shift + Home | Extends the selection to the beginning of the worksheet. |
| Ctrl + End | Moves the selection to the last cell at the intersection of the last row and last column. |
| Page Up | Moves one page up. |
| Page Down | Moves one page down. |
| Shift + Page Up | Extends the selection upward by one page. |
| Shift + Page Down | Extends the selection downward by one page. |
| Ctrl + Left | Navigates to the previous non-blank cell in the same row. |
| Ctrl + Right | Navigates to the last non-blank cell in the same row. |
| Ctrl + Up | Navigates to the first non-blank cell in the same column. |
| Ctrl + Down | Navigates to the last non-blank cell in the same column. |
| Ctrl + Shift + Left | Extends the selection to the previous non-blank cell in the same row. |
| Ctrl + Shift + Right | Extends the selection to the last non-blank cell in the same row. |
| Ctrl + Shift + Up | Extends the selection to the first non-blank cell in the same column. |
| Ctrl + Shift + Down | Extends the selection to the last non-blank cell in the same column. |
| Shift + Up | Extends the selection to the previous row. |
| Shift + Down | Extends the selection to the next row. |
| Shift + Left | Extends the selection to the previous column. |
| Shift + Right | Extends the selection to the next column. |
| Shift + Home | Extends the selection to the first column in the worksheet. |
| Ctrl + Spacebar | Selects the entire column. |
| Shift + Spacebar | Selects the entire row. |
| Ctrl + D | Fills the selected cells downward. |
| Ctrl + R | Fills the selected cells to the right. |
Formatting
| Shortcut | Description |
|---|---|
| Ctrl + B | Applies or removes bold formatting. |
| Ctrl + I | Applies or removes italic formatting. |
| Ctrl + U | Applies or removes underline formatting. |
| Ctrl + 5 | Applies or removes strikethrough formatting. |
| Ctrl + & | Applies an outline border to the selected cells. |
| Ctrl + Shift + & | Apply an outline border to the cells that you’ve chosen. |
| Ctrl + Shift + ~ | Applies the General number format. |
| Ctrl + Shift + $ | Applies the Currency format with two decimal places and displays negative numbers in parentheses. |
| Ctrl + % | Applies the Percentage format with no decimal places. |
| Ctrl + ^ | Applies the Scientific number format with two decimal places. |
| Ctrl + Shift + # | Applies the Date format with the day, month, and year. |
| Ctrl + Shift + @ | Applies the Time format with the hour, minute, and AM or PM. |
| Ctrl + Shift + ! | Applies the Number format with two decimal places, a thousands separator, and a minus sign for negative values. |
Row and column operations
| Shortcut | Description |
|---|---|
| Ctrl + 9 | Hides the selected row. |
| Ctrl + 0 | Hides the selected column. |
| Ctrl + Shift + 9 | Unhide the selected rows. |
| Ctrl + Shift + 0 | Unhide the selected columns. |
Open menu navigation
| Shortcut | Description |
|---|---|
| Up arrow | Moves the focus to the previous item in an open menu. |
| Down arrow | Moves the focus to the next item in an open menu. |
| Alt + Down | Opens the data validation list or filter menu for the active cell. |
| Alt + Up | Closes the data validation list or filter menu. |
| Spacebar or Enter | Activates the selected menu item or button. |
Ribbon navigation
| Shortcut | Description |
|---|---|
| Alt | Focuses the active ribbon tab. |
| Alt + F | Opens the File menu. |
| Alt + H | Opens the Home tab. |
| Alt + N | Opens the Insert tab. |
| Alt + M | Opens the Formulas tab. |
| Alt + A | Opens the Data tab. |
| Alt + W | Opens the View tab. |
| Left arrow | Moves the focus to the previous item in the ribbon. |
| Right arrow | Moves the focus to the next item in the ribbon. |
| Alt + Down | Opens the selected ribbon dropdown menu. |
| Esc / Alt + Up | Closes the ribbon dropdown menu. |
| Ctrl + F8 | Expands or collapses the ribbon content. |
| Ctrl + Shift + U | Expands or collapses the formula bar. |
| Shift + Alt + K | Opens the List All Sheets dropdown. |