Filter data in a table in Numbers for iCloud
You can filter the data in a table to show only the data you’re interested in seeing. You filter data by creating rules that determine which rows in a table are visible.
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.
Filter the data in a table
You create filter rules based on the values in a column. Only rows that contain the specified value(s) in that column are shown; rows with columns that don’t match are hidden.
As you create rules, they’re applied to the table. If a table has multiple rules, they’re all applied, but you can choose whether to show rows that match all filters, or any filters.
Note: You can’t apply rules to a table with cells that have been merged across one or more rows, and you can’t merge cells while a table is filtered.
Click the Organize button
in the toolbar, then click Filter at the top of the sidebar on the right.Click Add a Filter, then choose the column you want to filter by.
An empty filter rule for the selected column appears.
Choose the type of filter from the first Filtering Rule pop-up menu (for example, Numbers), then choose a rule (for example, “greater than”) from the second pop-up menu. If necessary, enter a value for your rule.
For example, if you selected a number filter with “greater than” as the rule, type the number that you want the entries to be greater than.
Press Return (or Enter).
The table filters to show only the rows with values in the selected column that match the rule. If you don’t see the results you expect, make sure each table cell is formatted for the type of data it contains (for example, cells formatted using the Text data format should contain text).
To add another rule for the same column, click Or, then choose a new filter and rule.
You may want to have multiple rules for a single column, such as “Show rows that have ‘yes’ or ‘maybe’ in Column C.”
To add a rule for a different column, click Add a Filter, then repeat the steps above.
Choose whether you want to filter the table by all filters, or any filter from the “Show rows that match” pop-up menu.
For example, if you choose “any filter,” then a row only has to match one filter.
Note: You can’t add new rows while a table is being filtered. To add new rows, temporarily turn filters off (deselect the Filters checkbox in the Filter Table sidebar), then turn them on again when you’re finished adding rows.
Turn off or delete a filter
You can turn off all filters for a table (without deleting them), or delete selected filters.
Click the Organize button
in the toolbar, then click Filter at the top of the sidebar on the right.Do one of the following:
Turn off all filters: Deselect the Filters checkbox. To turn them back on, select the checkbox again.
Delete a filter: Move your cursor to the upper-right corner of the rule, then click the Trash icon that appears.