Page 20 - Computer - 7

Excel provides two ways to filter cell ranges:

1. On the basis of specific values in
the cell range.

2. On the basis of specific conditions 2
on values in the cell range.

To filter data on specific values in a cell
range: 1
1. Select the cell range that contains
the headings for the data.
2. On the Data tab, click the Filter
button in the Sort & Filter group.
The filter control appears next to
each column heading.
3. Click the filter control of the column heading on which you want to specify the filter condition.
The Filter menu appears which displays a list of all unique values in the column.

3

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.

18