Skip to main content

Hot keys list

Here is a list of hotkeys that you can use while working with DHTMLX Spreadsheet.

Editingโ€‹

Enteractivates editor in a cell
Ctrl + Enterstops cellโ€™s editing, leaves selection on the cell
F2opens editor in the selected cell
Esccloses editor in a cell without saving changes

Work with cell contentโ€‹

Ctrl+Ccopies the value of a cell
Ctrl+Vpastes the value into a cell, replacing any selected content
Ctrl+Xcuts the value of a cell
Ctrl+Zundoes the last action in a sheet
Ctrl+Yrepeats the last action in a sheet
Ctrl+Shift+Zrepeats the last action in a sheet
Ctrl+Bmakes the value of a cell bold
Ctrl+Imakes the value of a cell italic
Ctrl+Umakes the value of a cell underlined
Ctrl+Aselects all cells in a sheet
Deleteremoves the cell content, saving the applied styles
Backspaceremoves the cell content, saving the applied styles
note

Navigation works in case no cell is being edited.

Enteractivates 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 + Entermoves 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.
Tabmoves 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 + Shiftmoves 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 keysprovide navigation around cells in a sheet
Homemoves selection to the first cell in the row
Endmoves selection to the last cell in the row
Ctrl + Left Arrow Keymoves selection to the first cell in a row
Ctrl + Right Arrow Keymoves selection to the last cell in a row
Ctrl + Up Arrow Keymoves selection to the first cell in a column
Ctrl + Down Arrow Keymoves selection to the last cell in a column
Ctrl + Homemoves selection to the beginning of a sheet (top left-hand cell)
Ctrl + Endmoves selection to the end of a sheet (bottom right-hand cell)
Shift + Up Arrow/Down Arrow/Left Arrow/Right Arrow Keyextends selection from the selected cell
Page Upscrolls the sheet one screen up
Page Downscrolls the sheet one screen down

Selectionโ€‹

Ctrl + Left clickallows selecting multiple scattered cells
Left Shift + Left clickallows 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 clickallows selecting multiple scattered ranges of cells