Basic Workbook and Worksheet Operations

The Origin workbook is structured like a notebook and can contain between 1 and 255 Origin worksheets. Worksheets may be rearranged or renamed, or they may be added, deleted, or "torn out" of the workbook Normally, each worksheet contains two or more columns of data but may contain anywhere from zero to 65368 or more columns.

Opening a new workbook

Unless modified, the default Origin project file contains a single, blank workbook window named Book1. This workbook window contains a single worksheet named Sheet1. As noted, you can add up to 225 worksheets to the workbook and your Origin project file (.OPJ) can contain any number of workbooks.

To open a new workbook:

1. Click the New Workbook button on the Standard toolbar.

To create a new workbook window by "tearing out" an existing worksheet:

1. Point to the worksheet tab.
2. Press and hold the left mouse button.
3. Drag the worksheet to an empty portion of the Origin workspace. The worksheet is "torn out" of the current workbook window and is added to a new workbook window.

To create a new workbook window by "tearing out" a copy of an existing worksheet:

1. Point to the worksheet tab.
2. Press and hold the left mouse button while holding down the keyboard CTRL key.
3. Drag the worksheet to an empty portion of the Origin workspace. A new workbook window is created from a copy of the worksheet.

Adding a new worksheet to the workbook

To add a new worksheet to the workbook:

1. Right-click on a worksheet tab (any in the workbook) and choose Insert, Add, or Duplicate Without Data.

To add an existing worksheet to another workbook:

1. Point to the worksheet tab.
2. Press and hold the left mouse button.
3. Drag the worksheet to the new workbook.

To add a copy of an existing worksheet to another workbook:

1. Point to the worksheet tab.
2. Press and hold the left mouse button while holding down the keyboard CTRL key.
3. Drag the worksheet to the new workbook. A copy of the worksheet is added to the workbook window.

Naming and labelling workbooks

To name or label workbooks:

1. Right click on the workbook title bar and choose Properties.
2. Enter a Long Name, Short Name and (optionally) Comments.
3. In the Window Title group, choose to display the Long Name, Short Name or Both.

For information on workbook naming conventions, see Origin Child Window Naming Conventions.

Naming the worksheet

To name the worksheet:

1. Right click on the worksheet tab and choose Rename.
2. Enter a new name (must be unique within the workbook).

For information on worksheet naming conventions, see Worksheet, Column and Cell Range Naming Conventions.

Scrolling and selecting workbook/worksheet data

For information on scrolling and selecting data in the worksheet, see Scrolling and Simple Data Selection in the Worksheet.

Zooming and Panning worksheet

Use these features to zoom in/out the worksheet:

• Press Ctrl key + mouse wheel to zoom in and out.
• Enter the percent in the Zoom combo tool.
• Press Ctrl + W to restore the entire page view.

Panning is also available for worksheet. Click the panning toolbar , then you can drag the columns horizontally and rows vertically to skim through all data sets.

Saving workbooks

To save a workbook window, including its data, as a separate file:

Select File: Save Window As. This opens the Save As dialog box. Workbooks (*.ogw) is selected (by default) from the Save as type drop-down list. Type the file name in the File name text box and select the desired destination folder.

Workbook templates

Workbook templates allow you to customize a workbook and save your customizations so that they can be recalled later. To learn more about workbook templates -- how they work and what information is saved with them -- see these topics:

• Workbook Templates
• What is Saved with a Workbook Template?