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 |