Numbers User Guide for Mac
- Intro to Numbers
- Intro to images, charts and other objects
- Create a spreadsheet
- Open or close spreadsheets
- Personalise templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Touch Bar for Numbers
- Use VoiceOver to create a spreadsheet
- Wrap text to fit in a cell
- Highlight cells
- Filter data
- Alphabetise or sort data in a table
- Modify chart data
- Move and resize charts
- Select text and place the insertion point
- Use a keyboard shortcut to apply a style
- Format lists
- Add and edit equations
- Add a highlight effect to text
- Add links
- Add rules (lines) to separate text
- Add lines and arrows
- Animate, share or save drawings
- Set movie and image formats
- Change object transparency
- Fill objects with colour or an image
- Add a border to an object or sheet
- Add a caption or title
- Add a reflection or shadow
- Use object styles
- Resize, rotate and flip objects
- Use iCloud with Numbers
- Import an Excel or text file
- Export to Excel or another file format
- Reduce the spreadsheet file size
- Save a large spreadsheet as a package file
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Lock a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates
Save and name a spreadsheet in Numbers on Mac
The first time you save a spreadsheet, you name it and choose where to save it — on your desktop or in a folder, for example. Thereafter, Numbers automatically saves your spreadsheet as you work. You can rename a spreadsheet at any time or create a duplicate of it with a different name.
Save and name a new spreadsheet
Click anywhere in the spreadsheet window to make it active, then choose File > Save (from the File menu at the top of your screen).
Enter a name in the Save As field, then enter one or more tags (optional).
Click the Where pop-up menu and choose a location.
If you want the spreadsheet to appear on all your devices set up with iCloud Drive, save the spreadsheet in the Numbers folder in iCloud Drive. (To see this option, iCloud Drive must be set up on your Mac.)
To create a new folder for the spreadsheet, click the Where pop-up menu, choose Other, then click New Folder at the bottom of the dialogue. Enter a name for the folder, then click Create.
Rename a spreadsheet
Click the spreadsheet name at the top of the Numbers window, then type a new name.
Click anywhere outside the dialogue to dismiss it.
Save a copy of a spreadsheet
With the spreadsheet open, hold down the Option key on your keyboard and choose File > Save As (from the File menu at the top of your screen).
Type a name for the copy, then press Return.
To save a copy of a spreadsheet in another format (for example, Microsoft Excel, PDF or Numbers ‘09), you make a copy of the spreadsheet in that format. To learn how, see Export to other file formats in Numbers on Mac.