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