Saving a Copy of a Spreadsheet
If you want to duplicate your open spreadsheet, you can save it using a different name
To save a copy of a spreadsheet in Mac OS X v10.7 (Lion) or later:
Choose File > Duplicate.
An untitled copy of the spreadsheet is created. Both copies remain open on your
desktop for you to view or edit.
Close the window of the untitled copy, type the spreadsheet’s name, and then choose
a location from the pop-up menu.
To save a copy of a spreadsheet in Mac OS X v10.6.x (Snow Leopard) or earlier:
Choose File > Save As and specify a name and location.
The spreadsheet with the new name remains open. To work with the previous version,
choose File > Open Recent and choose the previous version from the submenu.
You can also automate creating a backup version of the spreadsheet every time you
save, retaining the name and location of the original, but with the words “Backup of”
preceding the filename. See “Automatically Saving a Backup Version” on page 35.