To filter a list by the values in a column, click the down arrow on the right of the column header to display the in-column filter dialog.
Note: If the in-column filter arrows are not displayed, click the Customize Columns and Filter tool and select the Show column filter buttons option.
-
Select an operator from the first list and, if appropriate, select or enter an expression value to test against it. In this example, the list will be filtered to show only rows where the Name column contains values beginning with Cust*.
For an explanation of the available operators and the syntax for the expressions, see Defining a Filter Expression.
-
When you are satisfied with your criteria, click OK to apply the filter. The down arrow is overlaid with a filter symbol to show that a filter is applied, and any rows not meeting the criteria are hidden. In addition, to Enable/Disable Filter button is pressed. In this example, the Name=Cust* filter is applied:
-
[optional] Further restrict the rows displayed by defining a filter on any number of other columns. In this example, both the Name=Cust* filter and a Length<80 filter are applied:
Note: The filter criteria are stored in the Customize Columns and Filter dialog and remain applied until you remove them. To remove all filters, click to release the Enable/Disable Filter. To remove a filter from a single column, click the filter button in the column header, and then click the Clear Column Filter button.
