Get started with a template
All spreadsheets begin with a template — a model you can use as a starting point. Replace the template’s graphs and data with your own content and add new tables, formulas and more.
Add data to a table
Enter your own data or import data from another file. You can also add a wide range of formulas, like sum or average to any cell. To organise your data and identify trends, you can add filters, group data into categories, create pivot tables and more.
Create a graph
Illustrate your data with a 2D, 3D or interactive chart. When you make changes to the data in the table, the chart updates automatically.
Get organised with sheets
Organise your spreadsheet with different sheets for each type of information you want to track — income, expenses and so on. Then just tap a tab at the top of the spreadsheet to switch to the sheet you want to see.
Collaborate in real time
Invite others to work with you on your spreadsheet. Everyone you invite can see changes as they’re made, but you control who can edit or only view the spreadsheet.
This guide helps you get started using Numbers 12.1 on your iPad. (To see which version of Numbers you have go to Settings > Numbers.) To explore the Numbers User Guide tap Table of Contents at the top of the page, or enter a word or phrase in the search field. You can also download the guide from Apple Books (where available).
If you need more help, visit the Numbers Support website.
Numbers User Guide for iPad
- Intro to Numbers
- Intro to images, graphs and other objects
- Create a spreadsheet
- Open spreadsheets
- Prevent accidental editing
- Personalise templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Copy text and objects between apps
- Touchscreen basics
- Use Apple Pencil with Numbers
- Wrap text to fit in a cell
- Highlight cells
- Alphabetise or sort data in a table
- Filter data
- Modify graph data
- Move and resize graphs
- Select text and place the insertion point
- Change the look of text
- Use text styles
- Format lists
- Add and edit equations
- Add links
- 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
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates