4.2.1 Basic Operations on Worksheet
A workbook window has at least one worksheet. You can click the sheet tab at the bottom of workbook window to activate the worksheet you desired. Right-click on a sheet tab, you can perform some basic operations on current worksheet.
Insert, Delete and Add a Sheet
Right-click on the sheet tab to select Insert or Delete or Add item to insert a new sheet in front of current sheet or delete current sheet or add a new sheet as the last sheet.
Right-click on the sheet tab to select Add Graph as Sheet or Add Matrix as Sheet item to open the Hunt dialog(as below), click the window you want to add as a sheet to add the graph or matrix window as a new sheet into current workbook window.
Right-click on the sheet tab to select Add Notes as Sheet item to add a Notes window as a new sheet into the current workbook.
Copy and Paste a Sheet
From Origin 2018b, you are allowed to copy current sheet with all information(including the header lines and structure) into the clipboard, and then paste it as a new sheet from the clipboard into a workbook window, by right-clicking on the sheet tab and selecting Copy Sheet and Paste as New Sheet context menu item.
Once you selected the Copy Sheet item, you can
- right-click on Origin's gray work space to select Paste as New Sheet to paste this sheet as a new workbook.
- right-click on another sheet(might in another workbook window) to select Paste as New Sheet to paste this sheet as a new sheet into current workbook window.
- switch to another Origin session and select a sheet tab in the target workbook window, right-click it to select Paste as New Sheet to paste this sheet into the selected workbook of current Origin session. In this case, you are able to copy and paste a sheet between different Origin sessions.
Duplicate a Sheet
Right-click on the sheet tab, you can select Duplicate Without Data or Duplicate to duplicate the current worksheet with data or without data.
When you select Duplicate Without Data context menu item, a worksheet with same structure and header lines but without data will be created and added to the current workbook as the last worksheet.
When you select Duplicate context menu item, a new worksheet looks exactly alike will be created and added into current window as the last sheet.
Show Sheet Name, Manage Sheet Name and Comments
Right-click on the sheet tab and select Sheet Name to Show: Long Name if available/Short Name/Long Name context menu to decide which name of the sheet you want to show at the sheet tab. The default option is Short Name.
Right-click on any sheet tab, and then click Name and Comments... context menu to open the Name and Comments dialog to manage the name and comments in the current worksheet.
With this dialog, you can specify a Long/ Short Name and Comments in this dialog. The default option for Sheet Name to Show is Short Name, just consistent with the context menu Sheet Name to Show above.
To undo changes, press CTRL+Z.
Tag Sheet as Exclude from Plotting Dialogs
Right-click on the sheet tab and select Exclude from Plotting Dialogs context menu to exclude current sheet(s) as from the plotting dialogs, such as Plot Setup, Layer Contents etc..
You can also run the LabTalk command
wks.epd = 1; to execute this operation on current active sheet.
Additionally, you are allowed to perform this operation on multiple sheets in one time by
- Press Ctrl key to select multiple sheets, and then right-click to select Exclude from Plotting Dialogs context menu.
Once the sheets have been tagged as exclude, their names will be indicated with a specified color which is controlled by the system variable @TCE.
Tag Sheet as Exclude from Excel Export
Right-click on the sheet tab and select Exclude from Excel Export context menu to exclude current sheet from exporting the whole workbook as an Excel file.
Right-clicking on the sheet tab to select Navigate... context menu will open the Navigate Worksheets dialog box which can be used to manage the worksheets in current workbook. To learn the details about this dialog, please refer to this page.
Zoom and Pan Worksheet
To zoom the Worksheet,
To pan the Worksheet: