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
Copy, move or delete cell content in Numbers on iPad
Copy or move cell content
When you copy a cell or move a cell’s data to a new location in the table, the cell’s properties are also copied or moved, including its data format, fill, border and comments.
Select the cells you want to copy or move.
Do one of the following:
Paste and overwrite existing content: Tap Copy (if you don’t see Copy, tap the selected cells again). Select the top-left cell where you want to paste the data, then tap Paste (if you don’t see Paste, tap the cell again).
If your data range contains formulas, tap Paste Formulas or Paste Values. The data overwrites any existing data.
Move the data: Touch and hold the selection until the cells appear to rise off the table, then drag them to another location in the table. Existing data is replaced by the new data.
Paste outside of an existing table to create a new table: Tap Copy (if you don’t see Copy, tap the selected cells again). Tap the sheet outside the table, tap the sheet again to see the contextual menu, then tap Paste. A new table is created with the pasted cells.
You can also copy cells from a table in another spreadsheet, from Pages or Keynote.
Delete content from cells
Select one or more cells, then tap Delete (if you don’t see Delete, tap the cell again).