Tip:
Highlight text to annotate it
X
Filter a Range.
You can analyze table data much faster by filtering the data. Filtering a table means
that you configure a field so that you only view the table records that you want to work
with. One way to do this is to use the AutoFilter feature, which presents you with a list of
check boxes for each unique value in a field. You filter the data by activating the check
boxes for the records you want to see.
Click inside the table.
Click the Data tab.
Click Filter.
Excel adds to each field an arrow icon.
Click this icon for the field you want to use as the filter.
Excel displays a list of the unique values in the field.
Click the check box for each value you want to see.
Click OK.
Excel filters the table to show only those records that have the field values you selected.
Excel displays the number of records found.
The field's drop-down list displays a filter icon different.
To remove the filter, click Filter.