Page 17 - Code & Click - 7

4. Remove the check marks for the values you don’t want to display.

OR
Remove the check mark before Select All and check mark the
values you want to display.

5. Click the OK button.
Excel displays the rows containing the cells that match your filter
condition.

4

5

The row numbers of the filtered rows turn blue. A filter icon appears in the column heading.

Knowledge Discovery Subject Enrichment

Filter feature works well if you have headings for your data.

Custom Filtering 2

Custom Filter helps you filter data based on
specific conditions on values in cell range.
To apply Custom Filter:

1. Click a cell in the range that you want to
filter.
2. Click the filter control of the column
heading on which you want to specify
the filter condition.

1

3. Point to the Number Filters or Text Filters option and
select one of the predefined conditions, or Customised
Filter... from the sub-menu that appears.
The Custom Auto-filter dialog box opens.

3

15