The keyboard shortcuts supported in the spreadsheet are,
| Shortcut | Description |
|---|---|
| Ctrl + O | Displays dialog to open a file. |
| Ctrl + S | Saves the workbook. |
| F2 | Enables edit mode. |
| ESC | Cancel edit mode and discard the changes. |
| Backspace and SPACE | Clears content of the active cell and enables edit mode. |
| Ctrl + C | Copies the selected cells. |
| Ctrl + X | Cuts the selected cells. |
| Ctrl + V | Paste the clipboard(cut or copied) content in the new selected range. |
| Ctrl + B | Applies or removes bold formatting. |
| Ctrl + I | Applies or removes italic formatting. |
| Ctrl + U | Applies or removes underline. |
| Ctrl + 5 | Applies or removes |
| Ctrl + Z | Reverses (Undo) the last action. |
| Ctrl + Y | Repeats (Redo) the last reversed action. |
| Ctrl + K | It opens the Insert Hyperlink dialog for adding new hyperlink to a cell. If the selected cell already contains hyperlink, it opens the Edit Hyperlink dialog. |
| Ctrl + F | Opens Find dialog. |
| Ctrl + H | Opens Find and Replace dialog. |
| Ctrl + G | Opens GoTo dialog, which helps to navigate to cell. |
| Ctrl + Shift + L | Applies filter to the first row of the selected range or used range. |
| Alt + F | Opens the File menu. |
| Alt + H | Go to Home tab. |
| Alt + N | Go to Insert tab. |
| Alt + M | Go to Formulas tab. |
| Alt + A | Go to Data tab. |
| Alt + W | Go to View tab. |
| Tab | Move the focus to first or next item in current tab ribbon content if the focus is on ribbon. |
| Shift + Tab | Move the focus to previous item in current tab ribbon content if the focus is on ribbon. |
| Right or Left arrow | Move the focus to next or previous item in the tab if the focus is on ribbon tab. |
| Up arrow | When a menu is open, move focus to the next item. |
| Down arrow | When a menu is open, move focus to the previous item. |
| Spacebar or Enter | Activate a selected button. |
| Ctrl + F8 | Expand or collapse the ribbon content. |
| Ctrl + Shift + U | Expand or collapse the formula bar. |
| Ctrl + 9 | Hide the selected row. |
| Ctrl + 0 | Hide the selected column. |
| Home | Moves the selection to starting column in worksheet. |
| Ctrl + Home | Move to the first cell on a worksheet, left most first row and first column cell (A1). |
| Ctrl + Shift + Home | Extend the selection of cells to the beginning of the worksheet. |
| Ctrl + End | Move to the last cell on a worksheet, right most last column and last row cell. |
| Ctrl + & | Apply an outline border to the selected cells. |
| Ctrl + Shift + & | Remove the outline border from the selected cells. |
| Ctrl + Shift + ~ | Apply the General number format. |
| Ctrl + Shift + $ | Apply the Currency format with two decimal places (negative numbers in parentheses). |
| Shift + F10 | Add new sheet. |
| Ctrl + % | Apply the Percentage format with no decimal places. |
| Ctrl + ^ | Apply the Scientific number format with two decimal places. |
| Ctrl + Shift + # | Apply the Date format with the day, month, and year. |
| Ctrl + Shift + @ | Apply the Time format with the hour and minute, and AM or PM. |
| Ctrl + Shift + ! | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| Ctrl + Spacebar | Select an entire column in a worksheet. |
| Shift + Spacebar | Select an entire row in a worksheet. |
| Shift + F3 | Opens Insert Function dialog. |
| Ctrl + Alt + N | Opens new workbook. |
| Shift + Page Down | Perform page down by selecting all cells between. |
| Shift + Page Up | Perform page up by selecting all cells between. |
| Ctrl + Left | Navigate to the last non-blank cell in the same column as the active cell. |
| Ctrl + Right | Navigate to the first non-blank cell in the same column as the active cell. |
| Ctrl + Up | Navigate to the first non-blank cell in the same row as the active cell. |
| Ctrl + Down | Navigate to the last non-blank cell in the same row as the active cell. |
| Ctrl + Shift + Left | Extend the selection of cells to the last non-blank cell in the same column as the active cell. |
| Ctrl + Shift + Right | Extend the selection of cells to the first non-blank cell in the same column as the active cell. |
| Ctrl + Shift + Up | Extend the selection of cells to the first non-blank cell in the same row as the active cell. |
| Ctrl + Shift + Down | Extend the selection of cells to the last non-blank cell in the same row as the active cell. |
| Shift + Alt + K | Opens List All Sheets. |