Edit this page

List of Keyboard Shortcuts

The following table provides a list of the keyboard shortcuts the Spreadsheet supports.

Shortcuts Description
Ctrl + A Selects the whole worksheet
Ctrl + C Copies selected cells
Ctrl + P Displays the Print dialog box
Ctrl + S Saves the active spreadsheet file
Ctrl + V Inserts copied or cut cells to a selected location within the worksheet
Ctrl + X Cuts selected cells
Ctrl + Y Repeats the last action, if possible by using the Redo command
Ctrl + Z Reverses the last action or deletes the last typed entry by using the Undo command
Ctrl + select a cell Selects an adjacent or non adjacent cell
Ctrl + select cells Selects a range of adjacent or nonadjacent cells. To simultaneously select more than one range of cells, repeat this command. The selected ranges can also overlap.
Ctrl + select a row or column Selects an adjacent or nonadjacent row or column.
Ctrl + select rows or columns Selects a range of adjacent or nonadjacent rows or columns. To simultaneously select more than one range of rows or columns, repeat this command. The selected ranges can also overlap.
Esc Cancels an entry in a cell or in the Formula Bar
Arrow keys Move a cell up, down, left, or right in a worksheet
Ctrl + Arrow key Moves to the edge of the current data region of the active worksheet
Shift + Arrow key Selects (a range of) adjacent cells, rows, or columns, by extending the selection by one cell, row, or column
Ctrl + Shift + Arrow key Extends the selection of cells to the last nonblank cell in the same row or column as the active cell
Down Arrow / Up Arrow key
  • Selects the next or previous command when a menu or submenu is open
  • In a dialog box, the arrow keys move between options in an active drop-down list, or between options in a group of options
Backspace
  • Deletes one character to the left in the Formula Bar
  • Removes the content of the active cell
  • In cell editing mode, it deletes the character to the left of the insertion point
Delete
  • Removes the content from selected cells without affecting cell formats
  • In cell editing mode, it deletes the character to the right of the insertion point
End
  • Goes to the far right cell of the active row
  • Selects the last command on a visible and active menu or submenu
Ctrl + End
  • Moves to the last cell on a worksheet, in the lowest used row of the used column on the far right
  • If the cursor is in the formula bar, Ctrl + End moves the cursor to the end of the text
  • Ctrl + End moves to the last cell on a worksheet, in the lowest used row of the used column on the far right
Ctrl + Shift + End
  • Extends the selection of cells to the last used cell on the worksheet located in lower-right corner
  • If the cursor is in the formula bar, Ctrl + Shift + End selects all text in the formula bar from the cursor position to the end
Enter
  • Completes a cell entry from the cell or the Formula Bar, and selects the cell below
  • In a data form, it moves to the first field in the next record
  • Opens a selected menu or performs the action for a selected command
  • In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline)
Esc
  • Cancels an entry in the cell or Formula Bar
  • Closes an open menu or submenu, dialog box, or message window
Home
  • Moves to the beginning of a row in a worksheet
  • Selects the first command on the menu when a menu or submenu is visible
Ctrl + Home Moves to the beginning of a worksheet
Ctrl + Shift + Home Extends the selection of cells to the beginning of the worksheet
Page Down Moves one screen down in a worksheet
Page Up Moves one screen up in a worksheet
Spacebar In a dialog box, performs the action for the selected button, or selects or clears a check box
Alt + Spacebar Displays the Control menu for the Spreadsheet window
Tab
  • Moves one cell to the right in a worksheet
  • Moves to the next option or option group in a dialog box
  • Moves a cell within an active range of cells, rows, or columns.
Shift + Tab Moves to the previous cell in a worksheet or the previous option in a dialog box

See Also

Other articles on Kendo UI Spreadsheet:

Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy