Filter basic

Use the Filter dialog box to display only those rows that match the specified criteria.

Note:

To filter a large amount of data, use the Advanced tab to generate results more quickly. In the Basic tab, each column is searched in every row until a column with a match is found.

Enter the text you want to filter for. Use the following sorting criteria to qualify the filter:

Starts with	Show rows that contain the columns that match the first character(s) of the item.
Contains	Show rows that contain the columns that match the sequence of characters of the item.
Is exactly	Show rows that contain the columns that match the item exactly.
Match case	Check to perform a case-sensitive comparison.
Filter Previous Results	Check to filter the table again with additional criteria. If this option is not checked, the filter acts on the unfiltered table.
Clear button	Click to remove all filtering criteria from the Filter dialog box.
Filter button	Click to apply the filtering criteria.
Cancel button	Click to close the dialog box without performing a search.