Numbers User Guide for iPhone
- Welcome
- What’s new
-
- Get started with 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
- Touchscreen basics
- Change Numbers privacy and analytics settings
- Copyright
Create a pivot table in Numbers on iPhone
You can create a pivot table to organize, group, and summarize data from another table; the data in the other table is your source data.
Source tables for pivot tables must:
Have at least one cell with data that’s not a header cell.
Not include cells merged across adjacent rows.
If you create a pivot table from a range of cells, you can edit the range later.
If you update the source data in the original table, you need to refresh the pivot table to see the changes.
Create a pivot table
Go to the Numbers app
on your iPhone.Open a spreadsheet, then select a table or range of cells.
Tap
, 
, 
, or 
; then choose one of the following:Create Pivot Table: Creates a pivot table on a new sheet using the entire table as source data.
Create Pivot Table for Selected Cells: Creates a pivot table on a new sheet using only the selected cells as source data.
When you create a pivot table, it is blank until you add fields. See Add and arrange pivot table data.
Delete a pivot table
Go to the Numbers app
on your iPhone.Open a spreadsheet, select a pivot table, then tap Delete.
When you create a pivot table, you can create a chart to display the summary data. See Select cells in a pivot table to create a pivot chart.