Question

how do you use a simple filter on data ​

Answer 1

Answer:

To filter data:

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.

I think it's helpful to you

Answer 2

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