Keyboard shortcuts in Vue Spreadsheet component

16 Mar 202310 minutes to read

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 strikethrough.
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.

Note

You can refer to our Vue Spreadsheet feature tour page for its groundbreaking feature representations. You can also explore our Vue Spreadsheet example to knows how to present and manipulate data.

See Also