Numbers User Guide for iPad
- Intro to Numbers
- Intro to images, charts 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 chart data
- Move and resize charts
- 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
Create a spreadsheet in Numbers on iPad
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
Note: If you’d like the ability to format table and chart data using the conventions of another language, choose the language before choosing a template. See Change a spreadsheet’s language and formatting.
Tap a spreadsheet template to open it.
Scroll to see all the templates, or tap a category at the top.
Do any of the following to customise your spreadsheet:
Tap a table cell to delete placeholder content and add your own.
Tap in the toolbar to add other tables, text boxes, shapes and images.
Arrange the sheet by dragging tables and objects to where you want them.
To close the spreadsheet, tap Spreadsheets or in the top-left corner of the screen.
Your spreadsheet is saved automatically as you work, so you don’t lose your work when you close the spreadsheet. Closing the spreadsheet doesn’t quit Numbers.