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 (Cmd) + 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 |
Formatting cells
| Ctrl (Cmd) + C | copies the value of a cell |
| Ctrl (Cmd) + V | pastes the value into a cell, replacing any selected content |
| Ctrl (Cmd) + X | cuts the value of a cell |
| Ctrl (Cmd) + Z | undoes the last action in a sheet |
| Ctrl (Cmd) + Y | repeats the last action in a sheet |
| Ctrl (Cmd) + Shift + Z | repeats the last action in a sheet |
| Ctrl (Cmd) + B | makes the value of a cell bold |
| Ctrl (Cmd) + I | makes the value of a cell italic |
| Ctrl (Cmd) + U | makes the value of a cell underlined |
| Alt + Shift + 5 (Cmd + Shift + X) | makes the value of a cell crossed out |
| Ctrl (Cmd) + Shift + E | centers the value of a cell horizontally |
| Ctrl (Cmd) + Shift + R | aligns the value of a cell to the right |
| Ctrl (Cmd) + Shift + L | aligns the value of a cell to the left |
| Ctrl (Cmd) + K | inserts a hyperlink in a cell |
| 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 (Cmd) + Left Arrow Key | moves selection to the first cell in a row |
| Ctrl (Cmd) + Right Arrow Key | moves selection to the last cell in a row |
| Ctrl (Cmd) + Up Arrow Key | moves selection to the first cell in a column |
| Ctrl (Cmd) + Down Arrow Key | moves selection to the last cell in a column |
| Ctrl (Cmd) + Home | moves selection to the beginning of a sheet (top left-hand cell) |
| Ctrl (Cmd) + 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 |
Search
| Ctrl (Cmd) + F | opens a search box in the top right corner of the spreadsheet |
| Ctrl (Cmd) + G | moves selection to the next found match |
| Ctrl (Cmd) + Shift + G | moves selection to the previous found match |
Selection
| Ctrl (Cmd) + A | selects all cells in a sheet |
| Ctrl (Cmd) + 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 (Cmd) + Shift + Left click | allows selecting multiple scattered ranges of cells |
| Ctrl (Cmd) + Space | selects the whole column |
| Shift + Space | selects the whole row |
Work with sheets
| Shift + F11 | adds a new sheet into the spreadsheet |
| Alt + Arrow Up/ Arrow Down | switches to the next/previous sheet |