Use the Navigate Worksheets dialog to manage worksheets in the current workbook. Right-click any sheet tab, and then click Navigate... to open this dialog.
In the worksheet table, you can
You can press Ctrl/Shift key to select multiple sheets, and then perform these operations on them simultaneously with the Actions menu or the right-clicking context menu.
| Activate | Activate the selected worksheet. |
|---|---|
| Duplicate | Duplicate the selected worksheet with data. |
| Duplicate without Data | Duplicate the selected worksheet without data. |
| Clear all Data | Clear the data in selected worksheet. |
| Delete | Delete current selected worksheet |
| Move Before/ to Behind/ to End |
Move the selected worksheet to specified position. |
| Set Current Order as Sheet Order | Re-order the worksheets according to current order. |
| Exclude from Plotting dialogs | Exclude selected sheets when do plotting with the Plotting dialogs, such as Plot Setup, Layer Contents etc.. |
| Move to | Move the selected worksheet to
|
| Duplicate to New Book | Duplicate selected worksheet to a new workbook. |