Question

how does auto filters work in excel ​

Answer 1

Answer:

Follow these steps to apply an AutoFilter:

1) Select the data you want to filter.

2)Click Data > Filter.

3)Click the arrow Filter arrow in the column header and decide if you want to choose specific values or search.

4)Choose specific values: Uncheck (Select All) to clear all of the check boxes, and then check the boxes for the specific value(s) you want to see.

5)Search for values: In the Search box, type text or numbers that you seek.

6)I Click OK to apply the filter.

Answer 2

Answer:

Follow these steps to apply an AutoFilter:

Select the data you want to filter.

Click Data > Filter.

Click the arrow Filter arrow in the column header and decide if you want to choose specific values or search.

Filter button

Choose specific values: Uncheck (Select All) to clear all of the check boxes, and then check the boxes for the specific value(s) you want to see.

Filter by selecting items in a list

Search for values: In the Search box, type text or numbers that you seek.

Filter by searching

Click OK to apply the filter.