![](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150C60D78F13600351D8/en_AU/61e57fb81071150c7da08e52bb0d3db6.png)
Filter data in Numbers on iPhone
You can filter the data in a table to show only the data you want to see. For example, if you’re looking at a table of possible monthly mortgage payments for a loan with various interest rates, you can filter the table to show only the loans you can afford.
You filter data by creating rules that determine which rows in a table are visible. For example, you can create a filtering rule that shows rows that contain a number greater than a certain value, or text that contains a certain word, or you can use Quick Filters to quickly show or hide rows.
![A mortgage table shown before filtering for affordable interest rates.](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150C60D78F13600351D8/en_AU/4d8a0cd81bc8aed1778f03e3c0c2f94f.png)
![A mortgage table shown after filtering for affordable interest rates.](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150C60D78F13600351D8/en_AU/de53b28b2fb1d4699aae1a7ce83006c6.png)
Use Quick Filters
You can quickly show or hide rows that match a specific value in a column using Quick Filter. If you’re using Quick Filter in a pivot table, you can also hide (and show) groups in the Column and Row fields.
Select a column or cell.
If you want to use Quick Filters with a pivot table select a header cell, row or column.
Tap
or
at the bottom of the screen, then tap Quick Filter.
Select or deselect the tick box for the data you want to show or hide.
Tip: If you are working with a large set of data, and want to see only the items that are currently selected in the list, tap Show Selected.
When you’re finished, tap anywhere on the sheet.
To see your Quick Filter rules, tap , then tap Filter.
Create a filtering rule
You can create filtering rules based on the values in a column. Only rows with the specified values in that column appear. When you create a filtering rule for a pivot table, you can also create rules based on the fields.
Tap the table, tap
, then tap Filter.
Tap Add a Filter, then tap a column (or field) to filter by.
Tap the type of filter you want (for example, Text), then tap a rule (for example, “starts with”).
You can also choose a Quick Filter.
Enter values for your rule; for example, if you select “is not”, type text such as “due by”.
Tap Done.
To add another rule for the same column tap Add a Rule, then choose a new filtering rule.
You can have multiple rules for a column – for example, “Show rows that have ‘yes’ or ‘maybe’ in Column C”.
To add a filter to a different column, tap Add a Filter and choose another filtering rule.
In a table with multiple filtering rules, to show rows that match all filters or any filter, tap All Filters or Any Filter.
When you add rows to a filtered table, the cells are populated to meet the existing filtering rules.
Turn off filters or delete a rule
You can turn off all the filters for a table without deleting them. You can turn them back on later if necessary. If you don’t need a filter, you can delete it.
Tap the table, tap
, then tap Filter.
Do either of the following:
Turn off all filters: Turn off Filter Table.
Delete a rule: Swipe left on a rule, then tap Delete. To delete a filter, delete all its rules.