Question

what are the steps to filter data? in excel....​

Answer 1

Answer:

Begin with a worksheet that identifies each column using a header row. ...

Select the Data tab, then locate the Sort & Filter group.

Click the Filter command. ...

Drop-down arrows will appear in the header of each column.

Click the drop-down arrow for the column you want to filter. ...

The Filter menu appears.

Answer 2

Answer:

1. Click any single cell inside a data set.

2. On the Data tab, in the Sort & Filter group, click Filter.

3. Click the arrow next to Country.

4. Click on Select All to clear all the check boxes, and click the check box next to USA.

5. Click OK.

Result. Excel only displays the sales in the USA

6. Click the arrow next to Quarter.

7. Click on Select All to clear all the check boxes, nd click the check box next to Qtr 4.

8. Click OK.

Result.Excel only displays the sales in the USA in Qtr 4.

9. To remove the filter, on the Data tab, in the Sort & Filter group, click Clear. To remove the filter and the arrows, click Filter.

I think this is the proper step ..thanks