5.1 Basic Matrix Book and Matrix Sheet Operations


The matrix book can contain between 1 and 255 sheets. If you delete all sheets, the matrix book is deleted. Sheets may be rearranged or renamed. Sheets can also be "torn out" and added to other matrix books or dropped onto an empty portion of the workspace to create a new matrix book. 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 matrix book

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

Adding a sheet to the matrix book

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

Copying and Pasting a Matrix Sheet between Matrix Books 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 matrix book.
  • right-click on another sheet(might in another matrix book window) to select Paste as New Sheet to paste this sheet as a new sheet into current matrix book window.
  • switch to another Origin session and select a sheet tab in the target matrix book window, right-click it to select Paste as New Sheet to paste this sheet into the selected matrix book of the Origin session. In this case, you are able to copy and paste a matrix sheet between different Origin sessions.

Adding a matrix object to the matrix sheet

  • Click on the object icon in the upper-right corner of the sheet and choose Add from the shortcut menu, or use hot keys Ctrl + D.
  • Use hot keys Ctrl + Shift + N to show thumbnails, then right click on one thumbnail and select 'Add from the context menu.

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

  • Click on the object button Matrix object button.png and choose Insert from the shortcut menu.
  • Use hot keys Ctrl + Shift + N to show thumbnails, and then right click on one thumbnail and select Insert from the context 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 matrix books

  • 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.

Matrix book templates

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

To find out how more matrix templates, see: