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.
|
|
 |
No comments:
Post a Comment