Use Numbers to create attractive and powerful spreadsheets on your Mac. More than 30 Apple-designed templates give you a head start creating budgets, invoices, team rosters, and more. Numbers can also open and export Microsoft Excel spreadsheets.
Start with a template—then add what you want. Select the sample text in the template, then type new text. To add images, drag a graphic file from your Mac to the placeholder image.
Get organized with sheets. Use multiple sheets or tabs to show different views of your information. For example, use one sheet for your budget, another for a table, and a third for notes. Click to add a new sheet. Drag a tab left or right to reorder sheets.
Formulas are a snap. Get built-in help for more than 250 powerful functions—just type the equal sign (=) in a cell, and you see a list of all the functions and their descriptions in the sidebar. Start typing a formula to get instant suggestions.
Tip: To get instant calculations for a series of values, select the range of cells containing the values. At the bottom of the window you’ll see the sum, average, minimum, maximum, and count of the selected values. Click the Menu button at the bottom right to see even more options.
Create pivot tables. Create a pivot table using a table or range of cells in a spreadsheet as your source data, then use it to analyze any set of data, quickly group and summarize values, and identify interesting patterns and trends. You can edit the cell range of your source data, add and arrange pivot table data, create a snapshot of a pivot table that you can copy to other apps, and more.
Use the Touch Bar with your 13-inch MacBook Pro. Tap Format, Autofill, or Formula to display the options shown below. Tap text style and format buttons to display more options for choosing color, justification, wrapping, and top/bottom alignment for text.
Tap Format to display these text formatting buttons:
Tap Autofill to display these autofill options:
Tap Formula to display the quick formula buttons:
Learn more. See the Numbers User Guide.