Create a spreadsheet in Numbers on Mac
To create a spreadsheet, you start with either a blank template, to which you can add tables, charts, text and other objects, or a predesigned template that has placeholder elements, including text and images. These templates, which are designed for purposes like personal finance, business and education, give you a great starting point, and you can modify them however you like.
Create a spreadsheet
To open Numbers, click the Numbers icon in the Dock, Launchpad or the Applications folder.
If the template chooser (shown below) doesn’t appear, click New Document in the bottom-left corner of the dialogue. You can also hold down the Option key and choose File > New (from the File menu at the top of your screen).
Note: If you’d like the ability to format table and chart data using the conventions of another language, choose the language in the bottom-left corner before choosing a template. See Format a spreadsheet for another language.
In the template chooser, browse templates by category or click All Templates, then double-click a template to open it.
To create a new spreadsheet from scratch, double-click the Blank template.
Do any of the following:
Add your own headers and data to a table: Select a table cell, then type.
Add other tables, text boxes, shapes and images: Click object buttons in the toolbar.
Arrange elements on the sheet: Drag tables and objects to where you want them.
To name and save your spreadsheet, choose File > Save, enter a name, choose a location, then click Save.
If iCloud Drive is set up on your Mac, Numbers saves the spreadsheet there by default.
You can change the name of the spreadsheet or change its location at any time.
To close the spreadsheet when you’ve finished working, click the red close button in the top-left corner of the window.
Numbers automatically saves your changes, so you won’t lose any of your work.
You can also set Numbers to open new spreadsheets from a template instead of from the template chooser. To learn how, see Create new spreadsheets from a specific template.