Filter data in Numbers on iPad

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.

1. Select a column or cell.

   If you want to use Quick Filters with a pivot table, select a header cell, row, or column.

2. Tap or at the bottom of the screen, then tap Quick Filter.

3. Select or deselect the checkbox 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.

4. When you’re finished, tap anywhere on the sheet.

To see your Quick Filter rules, tap , then tap Filter.

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.

1. Tap the table, tap , then tap Filter.

2. Tap Add a Filter, then tap a column (or field) to filter by.

3. 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.

4. Enter values for your rule; for example, if you select “is not,” type text such as “due by.”

5. Tap Done.

6. 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.”

   

7. To add a filter to a different column, tap Add a Filter and choose another filtering rule.

8. 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.

You can turn off all 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.

1. Tap the table, tap , then tap Filter.

2. 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.