4.4.1.Display Specific Records Using AutoFilter |
|
Click anywhere within the table range.
Click the Data tab.
Click the Filter button to turn it on.
|
|
|
Click the list arrow of the field to specify search criteria.
|
|
|
To use built-in filters, point to <Column Name> Filters,
and then select a filter option, such as Equals, Begins With, or Contains.
|
|
|
To clear a filter, click the list arrow of the field,
and then click Clear Filter From <Column Name>.
|
|
|
To clear all filters in a worksheet and redisplay all rows,
click the Clear button.
|
|
|
To reapply a filter, click the Reapply button.
|
|
|
To turn off AutoFilter, click the Filter button to deselect it.
|
|
|