...
You can set up sheet names, resize columns, collapse and show columns, rename worksheets, import worksheets from other workbooks, and more.
Anchor sheet_
sheet_ |
...
There are multiple ways to navigate between sheets within a workbook:
- Click the sheet tab you want to view a the bottom of the page.
- Select the Sheets menu and click the sheet you want to view.
- Click on the Sheet Dependencies button in the toolbar and switch between sheets by clicking on sheets that are dependent with each other
Renaming sheets
To change the name of a sheet:
- Right-click the sheet name and click Rename.
- Enter the new name and press Enter.
- To undo the change, right-click the name again and click Undo.
Deleting sheets in a workbook
To delete a sheet:
- Click the tab in the workbook that you want to delete.
- Right-click the tab and choose Delete.
- Click Delete.
Duplicating sheets in a workbook
You can duplicate workbook sheets. New sheets are named with the next available number appended to the sheet name.
To duplicate sheets in a workbook:
- Click the tab in the workbook.
- From the Workbook menu Sheets, select Duplicate Sheet or right-click the sheet tab and select Duplicate.
- In the Duplicate Worksheet, select the columns you want to copy to the new sheet and click Create Sheet Copy.
- If a sheet has actions applied to it, you have the option to copy both the logic and the data, or you can select the Copy data onlycheckbox to copy just the data.
...
title | As of Datameer v6.3 |
---|
In addition to the raw data of a sheet with formulas, joins, sorts, or clustering, you can also copy the underlying logic and actions of a sheet into a new sheet.
...
To reorder sheets within a workbook:
- Right-click the sheet tab.
- Select Move.
- Click the space between the current sheet tabs where you want the selected sheet to be placed.
Anchor sheet_dependency sheet_dependency
Displaying sheet dependency (graph overlay)
sheet_dependency | |
sheet_dependency |
...