Skip to main content

Duplicating a selected worksheet

Though most Save operations are on whole workspaces, occasionally a data matrix needs to be saved externally, perhaps because it is needed in a different workspace or with other software. In order to protect against overwriting an original, external, data file with a version which is under a (possibly temporary) selection, File>Save Data As will ignore selections and save the whole data. To force a save of only the selection, you must first duplicate the selected sheet, with Tools> Duplicate. Do this on the selected form of the WA fish diets %vol data – which has excluded A9, B3, B4 – to create a new datasheet, Data2, which will now not contain these samples when saved.