Apply a Filter

The values displayed for each column can be filtered based upon specified conditions.

  1. Click on the Filter icon on any row header (see red box below).
  2. Options are provided which let you filter by any value in the column.

  3. Alternatively, you can define a custom filter by selecting Custom from the list of options.
  4. The Custom Auto Filter dialog is displayed:

    You can also right-click on any column header, to invoke the following menu:

The Filter Editor option on this menu provides you with a more powerful filtering tool.

The following wildcards may be used when specifying values:

Wildcard Description Example Returns
_ represents any single character AAA_ AAA3, AAA4
% represents any series of characters AAA% AAA301, AAA-B2

Note: Not all column filters support the Like comparison operator.