You filter data by creating rules that determine which rows in a table are visible.

Select a column or cell, click the arrow on the columns border, then choose an option under Quick Filter.

Click the table. In the Organize sidebar, click the Filter tab.

Note: If the filter options arent available, your table might have cells merged across adjacent rows.

Click the merged cell, then choose Table Unmerge Cells (from the Table menu at the top of your screen).

If youre not sure where the merged cells are, select the table, then choose Table Unmerge All Cells.

Click the type of filter you want (for example, Text), then click a rule (for example, starts with).

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

The Filters checkbox is selected and the rule is applied to the table.

To add another rule for the same column, click Or, 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, click Add a Filter and enter another filtering rule.

If a table has multiple filtering rules, you can choose whether to show rows that match all filters or any filter in the pop-up menu at the top.

When you add rows to a filtered table, the cells are populated to meet the existing filtering rules.

Turn off filters or delete a filter You can turn off all filters for a table without deleting them.

Click the table, then in the Organize sidebar, click the Filter tab.

How To Filter On Excel For Mac