Filtering Data

To filter data:

1	Select one or more columns of data (by clicking on the column label).

2	Choose Data > Data Filter to display the Data Filter dialog box.

3	Select the filtering criteria.

If you select to filter by Scale, specify the scale that should be matched. If you select to filter by minimum and maximum, enter the minimum and maximum values of range to be matched.

4	Select the type of filtering.

Use single pass filtering to deactivate data for one filtering criterion. With cumulative filtering, data deactivated for one operation remains deactivated during subsequent filtering passes, regardless of the criterion.

5	Click OK to filter the data.

Click Apply instead of OK to repeat the process and filter more data or filter the data some more.

To undo the last or all data filtering, choose Data > Undo Data Filtering.