5.1 Basic Matrixbook and Matrixsheet Operations


The matrixbook can contain up to 1024 sheets. If you delete all sheets, the matrixbook is deleted. Sheets may be rearranged or renamed. Sheets can also be "torn out" and added to other matrixbooks or dropped onto an empty portion of the workspace to create a new matrixbook. Each sheet can contain up to 90 million cells. In practical terms, the maximum number will be likely be determined by available system resources.

Opening a new matrixbook

  • Click the New Matrix button on the Standard toolbar and select File: New: Matrix.
  • To create a new matrix window from an existing matrixsheet, point to the matrixsheet tab, hold down the left mouse button and drag the matrixsheet to an empty portion of the Origin workspace.

Adding a sheet to the matrixbook

  • Right-click on a sheet tab and choose Insert, Add, or Duplicate Without Data.
  • To add an existing sheet to another matrixbook, point to the matrixsheet tab, hold down the left mouse button and drag the sheet to the new matrixbook.

Copying and Pasting a Matrixsheet between Matrixbooks or Origin Sessions

Since Origin 2018b, you are allowed to copy current sheet into the clipboard, and then paste it as a new sheet from the clipboard into a matrix 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 matrixbook.
  • right-click on another sheet(might in another matrixbook window) to select Paste as New Sheet to paste this sheet as a new sheet into current matrixbook window.
  • switch to another Origin session and select a sheet tab in the target matrixbook window, right-click it to select Paste as New Sheet to paste this sheet into the selected matrixbook of the Origin session. In this case, you are able to copy and paste a matrixsheet between different Origin sessions.

Adding a matrix object to the matrixsheet

  • Use hot keys Ctrl + Shift + N to show thumbnails, then right click on one thumbnail and select Add from the context menu; or click on the object button Matrix object button.png and choose Add from the popup menu.


To insert a new matrix object ahead of the current matrix object:

  • Use hot keys Ctrl + Shift + N to show thumbnails, and then right click on one thumbnail and select Insert from the context menu; or click on the object button Matrix object button.png and choose Insert from the popup menu.

Modifying the appearance of matrices via the Properties dialog box

Some modification of the appearance of a matrix can be done using the Matrix Properties dialog, which can be opened by selecting Matrix: Set Properties from the Origin menu.

In this dialog, you can enter the width for the columns in the dialog and set the display format, digits and data type for the matrix data. Note that these settings are applied only to the active matrix object. To customize another matrix object in the same sheet, you can use the Previous button or the Next button to go to the object and then change the settings for it.

Modifying the appearance of matrices using the Format and Style toolbar buttons

Some matrix customizations can be made using Format and Style toolbar buttons. First, select that portion of the worksheet that you want to modify.

  • To modify the font, point size, etc, use the buttons on the Format toolbar.
  • To modify the font color, use the Font Color drop-down on the Style toolbar.
  • To modify the cell or column color, use the Fill Color button on the Style toolbar.
  • To add borders to (or remove borders from) the matrix cells, use the Borders button on the Style toolbar.

Saving matrixbooks

  • With the matrix active, select File: Save Window As. This action opens the Save As dialog box. Matrix (*.ogm) 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.

Matrixbook templates

Matrixbook customizations can be saved for later use by saving the customized window as a template file.

To find out how more matrix templates, see: