📄️ Hot keys list
Keyboard shortcuts of DHTMLX Spreadsheet for editing, formatting, navigation, selection, search, work with sheets, rows and columns, popups and dialogs.
📄️ Work with sheets
Add, remove, rename and switch sheets in DHTMLX Spreadsheet with the bottom toolbar and the sheet tabs, and refer to cells of other sheets in formulas.
📄️ Work with rows and columns
Work with rows and columns in DHTMLX Spreadsheet. Add and remove them, autofit and set the column width and row height, freeze, hide and show them.
🗃️ Work with cells
4 items
📄️ Searching for data
Search for data in DHTMLX Spreadsheet with the search bar. Open it with Ctrl (Cmd) + F or the Data menu, move between the matches and close it with Esc.
📄️ Sorting data
Sort data in DHTMLX Spreadsheet from A to Z or from Z to A by a column or by a selected range of cells with the Sort command of the context menu.
📄️ Filtering data
Filter data in DHTMLX Spreadsheet by condition or by values, open a filter with the keyboard, and clear or remove filters.
📄️ Excel import/export
Import data from Excel files into DHTMLX Spreadsheet and export it to .xlsx through the toolbar or the File menu.