4.2.2 Copying and Pasting Worksheet Data


Copy Worksheet Data

Origin provides several options to copy worksheet data from the source worksheet column(s).

Copy worksheet values by context menu

Select worksheet column(s), right click, select Copy and choose from the following:

Copy copy data with the display precision
Copy (full precision) copy data with the full precision
Copy (including label rows) copy both the labels and data(with display precision) of the source column(s)
Copy (formula) copy the formula of the source column(s) only
Copy (label rows) copy the label rows of the source column(s) only
Copy (formula and label rows) copy the formula and label rows only
Copy All copy formula, labels and data(with full precision) of the source column(s)


For more information, see FAQ-482: How do I copy data with maximum precision?.

Copy worksheet values by more flexible colcopy X-Function

Besides the straightforward copy methods mentioned above, there is also a more powerful and flexible dialog tool called colcopy. It allows you to copy column data format or labels, or whether nor not to copy the hidden rows when a filter is applied to the source column.

To open the colcopy dialog, select Worksheet:Copy Columns to... from the main menu,

or

Right click on a column and select Copy Columns to... from the shortcut menu.

If a filter is applied, the right-click Copy menu ignores the hidden rows by default. To change this default behavior to copy all rows, set system variable @iHR=1. Refer to System Variable list for more details.

Paste Worksheet Data

Origin provides several options to paste worksheet cell(s) to a new destination.

Select the worksheet column or a block of cells you want to copy, and select Edit: Copy. Select the first cell of the paste destination, right click on it and choose one of the following menu item depending on different purposes.

Paste paste the copied worksheet cell value(s) to the the destination
Paste Transpose transpose the copied cells block while pasting
Paste Link paste the copied cell value(s) as link(s), in which changes in the source cell(s) will trigger auto-update in the destination.
Paste Link Transpose paste the copied cell value(s) as link(s) and transpose the cell block while pasting

If you only copied one cell, you can paste that cell as link to multiple cells by select Edit: Paste Link.

If edit a linked worksheet cell, you'll notice the notation that is used. For example, cell://A[6] means this cell is linking to the 6th cell of col(A). Any value change in cell A[6] will trigger updates in all cells that have cell://A[6] automatically.