Save and rename a spreadsheet

Numbers automatically saves your spreadsheet as you work so you don’t have to. You can rename your spreadsheet, create different versions of it, and save it to another location.

Save a spreadsheet

Numbers gives a new spreadsheet a placeholder name such as Untitled 1 and saves it to a default location. You can specify a title for the spreadsheet and save it to a different location.

  1. Hold the Option key, then Choose File > Save As (from the File menu at the top of your computer screen).

  2. Enter a name in the Name field.

    Dialog for renaming a spreadsheet
  3. Enter one or more tags (optional).

  4. Choose where you want to save the spreadsheet.

    You can save it to a folder on your Mac or on a server, or save it to iCloud.

    Tip: If you don’t see the location you’re looking for in the pop-up menu, choose Other to see more options.

  5. Click Save.

When you save a spreadsheet to iCloud, it appears automatically on your iPad, iPhone, or iPod touch (if you set up iCloud on those devices) and updates it whenever you make changes to it on any computer or device signed in to your iCloud account.

Rename a spreadsheet

  • Click the spreadsheet’s name at the top of the Numbers window, then type a new name.

Click anywhere outside the dialog to dismiss it.

Duplicate a spreadsheet

To create a new copy of a spreadsheet, duplicate the original spreadsheet.

  1. Choose File > Duplicate.

    The new spreadsheet opens with its name selected at the top of the spreadsheet.

  2. Type a new name.

The duplicate copy is saved to the same location as the original.

Revert a spreadsheet to an earlier version

  1. Choose File > Revert To (from the File menu at the top of your computer screen), the choose one of the following:

    • Last Saved: All changes you made to the spreadsheet since you last saved it are deleted.

    • Last Opened: All changes you made to the spreadsheet since you last opened it are deleted.

    • Browse All Versions: The timeline for the spreadsheet opens, showing tick marks on the right that indicate every time the spreadsheet was opened, saved, duplicated, locked, renamed, or reverted.

  2. If you chose Browse All Versions, click the tick marks to display different versions.

  3. When you find the version you want, do one of the following:

    • Restore your spreadsheet to this version: Click Restore.

    • Duplicate this version in a new spreadsheet: Press the Option key and click “Restore a Copy.”

  4. To leave your spreadsheet without making any changes, click Done.

For information about exporting a spreadsheet, see Save a spreadsheet in another format.