Hot keys list
Here is a list of hotkeys that you can use while working with DHTMLX Spreadsheet.
Editing
Enter | activates editor in a cell |
Ctrl + Enter | stops cell’s editing, leaves selection on the cell |
F2 | opens editor in the selected cell |
Esc | closes editor in a cell without saving changes |
Work with cell content
Ctrl+C | copies the value of a cell |
Ctrl+V | pastes the value into a cell, replacing any selected content |
Ctrl+X | cuts the value of a cell |
Ctrl+Z | undoes the last action in a sheet |
Ctrl+Y | repeats the last action in a sheet |
Ctrl+Shift+Z | repeats the last action in a sheet |
Ctrl+B | makes the value of a cell bold |
Ctrl+I | makes the value of a cell italic |
Ctrl+U | makes the value of a cell underlined |
Ctrl+A | selects all cells in a sheet |
Delete | removes the cell content, saving the applied styles |
Backspace | removes the cell content, saving the applied styles |
Navigation
note
Navigation works in case no cell is being edited.
Enter | activates editor in a cell. Closes editor and moves selection one cell down (in a column). If a range of cells is selected, moves selection one cell down within the bounds of a range. |
Shift + Enter | moves selection one cell up (in a column). If a range of cells is selected, moves selection one cell up within the bounds of a range. Deactivated when reaches the first cell in a column. |
Tab | moves selection one cell right (in a row). If a range of cells is selected, moves selection one cell right within the bounds of a range. Deactivated when reaches the rightmost cell in a row. |
Tab + Shift | moves selection one cell left (in a row). If a range of cells is selected, moves selection one cell left within the bounds of a range. Deactivated when reaches the leftmost cell in a row. |
Arrow keys | provide navigation around cells in a sheet |
Home | moves selection to the first cell in the row |
End | moves selection to the last cell in the row |
Ctrl + Left Arrow Key | moves selection to the first cell in a row |
Ctrl + Right Arrow Key | moves selection to the last cell in a row |
Ctrl + Up Arrow Key | moves selection to the first cell in a column |
Ctrl + Down Arrow Key | moves selection to the last cell in a column |
Ctrl + Home | moves selection to the beginning of a sheet (top left-hand cell) |
Ctrl + End | moves selection to the end of a sheet (bottom right-hand cell) |
Shift + Up Arrow/Down Arrow/Left Arrow/Right Arrow Key | extends selection from the selected cell |
Page Up | scrolls the sheet one screen up |
Page Down | scrolls the sheet one screen down |
Selection
Ctrl + Left click | allows selecting multiple scattered cells |
Left Shift + Left click | allows selecting a range of cells, where the selected cell is the first cell of the range and the clicked cell is the last cell of the range |
Ctrl + Shift + Left click | allows selecting multiple scattered ranges of cells |