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
Add objects to cells in Numbers on iPad
You can paste images, shapes, lines, charts and equations into table cells. When you paste an object into a cell, it’s added as an image fill (background) in the cell. You can change how the object fills the cell, or add text that appears in front of the object.
Note: If you paste a shape that contains text, only the text is pasted into the cell.
Add an object to a cell
Tap an object in your spreadsheet, then tap Copy or Cut (cut removes it from its original location).
Tap the cell where you want to add the object.
Tap the cell again, then tap Paste.
By default, Numbers scales the object to fit in the cell. To change the object’s size, you can resize the row.
You can also copy an object from another spreadsheet or from Pages or Keynote.
Delete an object from a cell
Tap the cell, then tap .
Tap Cell at the top of the formatting controls.
Tap Cell Fill (you may need to swipe up to see it), tap Preset, then tap No Fill (you may need to swipe left to see it).
You can also add tickboxes, star ratings, sliders and pop-up menus to table cells. See Add controls to cells in Numbers on iPad.