Select menu: Spread | Manipulate | Duplicate
Create a second copy of the current spreadsheet, optionally changing the spreadsheet type and column names.
- From the menu select Spread | Manipulate | Duplicate.
- 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