138k views
3 votes
Order the steps to autofilter data

User Gelupa
by
4.5k points

2 Answers

4 votes

Answer:

Select the data you want to filter.

Click Data > Filter.

Click the arrow. ...

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.

Step-by-step explanation:

1. Select the data you want to filter.

2. Click Data > Filter.

3. Click the arrow. ...

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.

User Gxmad
by
4.7k points
5 votes

Answer:

Select any cell in the data range > Click the data tab > Go to the sort & filter group > Click filter and select proper controls

Step-by-step explanation:

i got it right lol :)

User Monika Patel
by
4.5k points