1. Home
  2. Duplicate a Spreadsheet

Duplicate a Spreadsheet

Select menu: Spread | Manipulate | Duplicate

Create a second copy of the current spreadsheet, optionally changing the spreadsheet type and column names.

  1. From the menu select Spread | Manipulate | Duplicate.
  2. Set options as required then click OK.

New sheet type

This controls the new type of the resulting spreadsheet. The spreadsheet on duplication can be converted to a new type. So, for example a matrix spreadsheet could be changed to a vector spreadsheet type.

Create unique column names

If checked, the column names in the new spreadsheet will be created with unique names so that they are different to the existing column names.

Only duplicate selected data

If checked, only the selected columns are used when creating the new spreadsheet. This provides a simple way of forming a subset from the columns of the current spreadsheet.

Only duplicate rows included by the restriction

If checked, only the rows included in a restriction/filter (the excluded rows are hidden or displayed in red) are used when creating the new spreadsheet. This provides a simple way of forming a subset from the rows of the current spreadsheet. This will only show if the spreadsheet has a restriction/filter applied to it.

Set as active sheet

Sets the newly created spreadsheet to be the active spreadsheet. See setting an active spreadsheet for more details.

Add to book

This provides a list of books that the new spreadsheet can be added to. The default book that spreadsheets are added to can be specified using the menu Tools | Spreadsheet Options then click the Books tab.

See also

Convert
Convert Multiple Columns
Expand a Spreadsheet using a Weight Column
Resize Spreadsheet
Spreadsheet Manipulate Menu
Creating a new spreadsheet
Restrict/filter menu

Updated on March 19, 2019

Was this article helpful?