Hot keys list
Here is a list of hotkeys that you can use while working with DHTMLX Spreadsheet.
note
The shortcuts for cells work while the focus is in the cells or in the formula bar. The formatting, undo, search, link and add-sheet shortcuts also work while the focus is on the toolbar. When the focus is on the toolbar, the menu bar or the sheet tabs, the arrow keys, Home, End, Enter and Space work within that bar (see Moving the focus).
In the read-only mode, the shortcuts for navigation, selection, copying and search work. The shortcuts that change the sheet, including Ctrl (Cmd) + Shift + 9, Ctrl (Cmd) + Shift + 0 and Shift + F11, are refused, and screen readers announce "The sheet is read-only". The context menu isn't available, so Shift + F10 and the Menu key don't work.
To learn how the keyboard navigation works with screen readers, check the Accessibility guide.
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 |
| Alt (Option) + Enter | opens the link of the active cell in a new tab |
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. |
| Tab | moves selection one cell right (in a row). From the rightmost cell, moves selection to the first cell of the same row. If a range of cells is selected, moves selection one cell right within the bounds of a range. From the last cell of the sheet, saves the edited value and moves the focus out of the cells to the next part of the page, for example, the sheet tabs. |
| Tab + Shift | moves selection one cell left (in a row). From the leftmost cell, moves selection to the last cell of the same row. If a range of cells is selected, moves selection one cell left within the bounds of a range. From the first cell of the sheet, saves the edited value and moves the focus out of the cells to the previous part of the page, for example, the formula bar. |
| Arrow keys | provide navigation around cells in a sheet. Stop at the first and last visible row and column. If a range of cells is selected, an arrow key at the edge of the sheet collapses the range to the active cell |
| Home | moves selection to the first visible cell in the row |
| End | moves selection to the last visible cell in the row |
| Ctrl (Cmd) + Left Arrow Key | moves selection to the first visible cell in a row |
| Ctrl (Cmd) + Right Arrow Key | moves selection to the last visible cell in a row |
| Ctrl (Cmd) + Up Arrow Key | moves selection to the first visible cell in a column |
| Ctrl (Cmd) + Down Arrow Key | moves selection to the last visible 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 |
Moving the focus
The toolbar, the menu bar and the sheet tabs are single tab stops: Tab moves the focus into a bar and out of it, and the focus lands on the control that was used last.
| Ctrl + F6 | moves the focus to the next part of the Spreadsheet in the order: the menu, the toolbar, the sheet (the active cell), the sheet tabs, and then back to the menu. The formula bar and hidden parts are skipped. Saves the value of the edited cell first |
| Ctrl + Shift + F6 | moves the focus to the previous part of the Spreadsheet |
| Left Arrow/Right Arrow Key | moves the focus to the previous/next control of the toolbar, the menu bar or the sheet tabs |
| Home/End | moves the focus to the first/last control of the bar |
| Enter/Space | presses the focused control: runs the command, opens the dropdown, or switches to the sheet of the focused tab |
| Down Arrow Key | opens the dropdown of the focused control and moves the focus to its first item |
| Up Arrow/Down Arrow Key | moves the focus between the items of an open dropdown or menu |
| Right Arrow Key | opens the submenu of the focused menu item |
| Left Arrow Key | closes the submenu. In the first level of a dropdown, closes the dropdown and returns the focus to its control |
| Esc | closes the dropdown or the menu and returns the focus to the control that opened it. Closes the tooltip of a toolbar control. Without Esc, the tooltip stays open while the pointer is over it |
| Shift + F10 or Menu key | opens the context menu of the active cell or of the focused sheet tab and moves the focus into it. After Ctrl (Cmd) + Space, the context menu of a cell shows the commands for the column. Esc closes the context menu and returns the focus to the cell |
Search
| Ctrl (Cmd) + F | opens a search box in the top right corner of the spreadsheet |
| Ctrl (Cmd) + G | highlights the next found match |
| Ctrl (Cmd) + Shift + G | highlights the previous found match |
| Esc | closes the search box and returns the focus to the active cell |
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 (Option) + Arrow Up | switches to the next sheet. From the last sheet, switches to the first one |
| Alt (Option) + Arrow Down | switches to the previous sheet. From the first sheet, switches to the last one |
| Ctrl (Cmd) + Alt (Option) + Page Down | switches to the next sheet |
| Ctrl (Cmd) + Alt (Option) + Page Up | switches to the previous sheet |
Work with rows and columns
| Ctrl (Cmd) + Shift + 9 | shows the hidden rows inside the selected range |
| Ctrl (Cmd) + Shift + 0 | shows the hidden columns inside the selected range |
Toolbar popups
The keys below work in the popups of the Text color, Background color and Border controls of the toolbar. The popup takes the focus when it opens.
| Arrow keys | move the focus between the colors of the palette or between the controls of the Border popup |
| Home/End | moves the focus to the first/last color of the palette |
| Enter | applies the focused color or border. After a text or background color is applied, the focus returns to the active cell |
| Esc | returns from the custom color mode to the palette. In a color or style popup opened over the Border popup, closes it and returns the focus to its button in the Border popup. Otherwise, closes the popup and returns the focus to its toolbar control |
| Tab/Tab + Shift | closes the popup and returns the focus to its toolbar control. In the Border popup and the popups opened over it, closes them all and returns the focus to the Border control. In the custom color mode, moves the focus between the controls of the color picker |
List editor
The keys below work in the editor of a cell with a list of values.
| Up Arrow/Down Arrow Key | moves through the list of values |
| Enter | chooses the value and closes the editor |
| Esc | closes the editor without saving changes |
| Tab | saves the value and moves selection one cell right |
Filter and dialogs
The keys below work in the popup of a filter and in the Column width and Row height dialogs.
| Esc | closes the filter popup and returns the focus to the cell |
| Enter | applies the size in the Column width and Row height dialogs |
| Esc | closes the Column width and Row height dialogs without changes |