Create a spreadsheet in Numbers on Mac
To create a new spreadsheet, you first choose a template to use as a starting point. Templates use coordinated fonts and colours for a unified look and often include placeholders that you can replace with your own content.
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 graph 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, then double-click the one that looks closest to what you want to create. To narrow the choices, click a category along the sidebar on the left.
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.
Choose File > Save, enter a name, choose a location, then click Save.
Numbers automatically saves your changes as you work, so you don’t need to worry about consistently saving your spreadsheet manually. However, it’s a good idea to rename your spreadsheet so you can easily find it the next time you want to work on it. You can change the name of the spreadsheet or change its location at any time.
If iCloud Drive is set up on your Mac, Numbers saves the spreadsheet there by default.
To close the spreadsheet, click the red close button in the top-left corner of the window.