Numbers User Guide for iPad
- Intro to Numbers
- Intro to images, charts, and other objects
- Create a spreadsheet
- Open spreadsheets
- Prevent accidental editing
- Personalize 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
- Customize the toolbar
- Touchscreen basics
- Use Apple Pencil with Numbers
- Wrap text to fit in a cell
- Highlight cells
- Alphabetize 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 color 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
Select the column or row (or the range of cells) whose calculations you want to see.
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 in a calculator.
Tap a blank cell where you want to add your formula, then type the equal 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 parentheses; if you type 4+6*(3-1), the cell returns the result of 16.