7.1 Working with Multi-Sheet Workbooks

Summary

Origin workbooks are similar to spreadsheets and can have multiple worksheets. Multi-sheet workbooks allow for better organization and higher information density.

What you will learn

This tutorial will teach you how to:

  • Add and arrange worksheets.
  • Handle metadata.
  • Split the worksheet into Panels using Dividers.

Steps

Adding and Arranging Worksheets

  1. Click the New Project button Button New Project.png on the Standard Toolbar.
  2. Right-click on the Sheet1' tab and choose Name and Comments. Enter Subjects as the Short Name in the Name and Comments dialog.
  3. Right-click on the tab of the sheet that was renamed in the last step, and choose Add. A second sheet, named Sheet1, will be added to the book.
  4. Double-click on the new Sheet1 tab and enter 2nd Test as the name in the font box that appears. (Alternately, right-click and use the the Name and Comments option again.)
  5. Right-click on the 2nd Test name and choose Insert. A new sheet, named Sheet1, is inserted between Subjects and 2nd Test. Rename the new sheet 1st Test.
  6. Left-click and hold down the mouse button on the 1st Test sheet name, drag the mouse over the Origin Workspace and release. The 1st Test sheet will now appear in its own workbook.
  7. Select Window: Tile Vertically to arrange the workbooks side by side as shown below:

    Working with Multi-Sheet Workbooks 2.png

  8. Drag 2nd Test to the second workbook. This will move the 2nd Test sheet from the original workbook to the new workbook as shown below:

    Working with Multi-Sheet Workbooks 3.png

  9. Click the Save button Button Save Project.png. The Save As dialog will open since the project is yet to be saved. Save this in the User Files Folder as Multi-Sheet Workbooks.opj
Note: It is also possible to drag and drop sheets within the workbook to change the order. Right-click on any sheet name and note these additional options: Duplicate Without Data, Duplicate, Delete and Navigate.

Handling Metadata

Add Metadata to the Worksheet

  1. Click the New Project button Button New Project.png on the Standard Toolbar.
  2. Select Format: Worksheet from the Origin menu (Alternatively press F4 or double-click on the gray area to the right of the columns). The Worksheet Properties dialog opens:

    Working with Multi-Sheet Workbooks 4.png

  3. On the View tab, click the Edit Column Label Rows button. The Column Label Rows dialog opens.
  4. Right-click on the table and select Add User-Defined Parameter. Scroll down to note that a UserDefined label has been added. The Show box is checked by default.

    Working with Multi-Sheet Workbooks 5.png

  5. Double-click on the UserDefined text (or single-click and press F2), and change the UserDefined text to Wavelength (nm).
  6. Click in the box to the left of Wavelength (nm) and drag it to the top of the list, dropping it above Long Name. This will change the order of the rows as shown below:

    Working with Multi-Sheet Workbooks 6.png

  7. Click OK to close the Column Label Rows dialog.
  8. Select the Format tab in the Worksheet Properties dialog, and choose LongName from the Apply To drop-down. Check the Rich Text box.

    Working with Multi-Sheet Workbooks 8.png

  9. Click OK to close the Worksheet Properties dialog box.
  10. Highlight the Comments row and click the Merge Cells button Button Merge Cells.png on the Style Toolbar to create a row with one cell.
  11. Enter the values shown below in the Columns A and B header region (Wavelength to Comments).
    (Note: Once the Rich Text box is checked for specified cells, double-clicking in the cells to edit them will activate the format buttons Buttons Rich Text.png. These can be used to apply rich text formatting as shown below):

    Working with Multi-Sheet Workbooks 9.png

View Metadata in the Workbook Organizer

  1. Click on the New Folder button Button New Folder.png.
  2. Click on the Import Single ASCII button Button Import Single ASCII.png.
  3. Browse to file S15-125-03.dat in Origin's Sample\Import and Export folder. The Show Options Dialog checkbox should be deselected by default. Click Open to import the file to Origin.
  4. Right-click on the workbook window title and choose Show Organizer from the context menu. The Worksheet Organizer will appear at the bottom of the worksheet.
  5. Expand the Imported Files branch and view the stored metadata.
    Working with Multi-Sheet Workbooks 11.png

Splitting Worksheets into Panels using Dividers

Split from Menu

  1. Activate the worksheet and highlight a cell.
  2. Select Window: Split from the Origin menu.
  3. The worksheet or matrix sheet will be divided into 4 panels by a horizontal and vertical Divider at the highlighted cell. To move the Divider to a new location, drag it to the desired row or column.
  4. Select Window:Remove Split from the Origin menu to hide the split pointers.
    (Note: This process is the same for worksheets and matrix sheets).

Split by Dragging the Divider

  1. Point the cursor to the bottom right of the sheet at the end of the vertical scroll bar (for a horizontal Divider) or at the right end of the horizontal scroll bar (for a vertical Divider) as shown below:
  2. When the pointer changes to a split pointer, drag it to the desired position. A horizontal or vertical Divider will be created.
    Working with Multi-Sheet Workbooks 12.png
    A worksheet with horizontal and vertical Dividers is shown below:
    Working with Multi-Sheet Workbooks 13.png