| sidebar_label | Work with sheets |
|---|---|
| title | Work with Sheets |
| description | You can learn about the work with sheets in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet. |
To add a new sheet, take the following steps:
-
Choose a sheet tab by clicking on it
-
Click the Add sheet button in the bottom toolbar
:::note Note, that a new sheet will be added after the currently active sheet. :::
To remove a sheet from the spreadsheet, right-click the sheet tab and choose Delete.
{{note Note, that a sheet can't be removed if it is the only sheet in the spreadsheet.}}
To change the currently active sheet, just click a different sheet tab with the mouse pointer.
To rename a sheet, right-click the sheet tab, click Rename, and type the new name.
You can easily consolidate data from multiple sheets into a single one by using cross-referencing.
For that, take the following steps:
1. Type an equal sign (=) into a cell
2. Click the sheet tab you want to cross-reference and select the cell or range of cells
3. Finish typing the formula and press Enter
