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
Quickly calculate a sum, average and more in Numbers on iPad
You can make calculations in your table without having to insert a formula or function.
Make quick calculations for a range of cells
Tap at the bottom of the screen, then tap the formula you want to use.
If you selected an entire row, tap or , then tap the formula you want to use.
The result of the formula appears at the end of your selection.
Use the Formula Editor like a calculator
You can enter number values in formulas to make calculations, just as you would on a calculator.
Tap a blank cell where you want to add your formula, then type the equals sign (=) to open the Formula Editor.
Type the equation you want to calculate, using values and arithmetic operators (for example, +,-,* and /).
For example, if you type the equal sign (=), then type “1+1” in the Formula Editor, the cell returns the result of 2. You can also use brackets; if you type 4+6*(3-1), the cell returns the result of 16.