Filtering the data enables you to extract
particular pieces of information.
To filter the data:
Select an active cell within the column you would like
the filter to be applied to. If you do not select a cell, the
filtering will be applied to the first column by default.
Click the Filter button.
Select the Operator radio button corresponding to the
condition you want to filter by e.g. = (equals), < (less than),
>= (greater than or equal to)
In the Value field, type the value you are
filtering for.
Click OK to apply the filter and close the dialog (or
Cancel to close the dialog without filtering).
Only the rows satisfying the entered filter parameters
should now display in the table.
Once a filter has been applied, you can reload the
original source table by clicking on the Filter button again and
selecting Clear. If an applied filter
didn't call up any matching entries, you can repopulate the
original table by simply clicking on the Filter button.
NOTE: When selecting a column to be
filtered, do not use the column heading field. The column headings
are used to sort a table in ascending or descending order, they
cannot be used to select active cells.