Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can set up sheet names, resize columns, collapse and show columns, rename worksheets, import worksheets from other workbooks, and more.

Anchor
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:

  1. Right-click the sheet name and click Rename.
  2. Enter the new name and press Enter.
  3. To undo the change, right-click the name again and click Undo.

Deleting sheets in a workbook

To delete a sheet:

  1. Click the tab in the workbook that you want to delete.
  2. Right-click the tab and choose Delete.
  3. 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:

  1. Click the tab in the workbook.
  2. From the Workbook menu Sheets, select Duplicate  Sheet or right-click the sheet tab and select Duplicate.
  3. In the Duplicate Worksheet, select the columns you want to copy to the new sheet and click Create  Sheet  Copy.
  4. 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.

...

titleAs 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:

  1. Right-click the sheet tab.
  2. Select Move.
  3. 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)

...