Excel - Filter your data

Select the data that you want to filter.
On the Data tab, in the Sort & Filter group, click Filter.

The Sort and Filter group on the Data tab

3. Click the arrow Filter drop-down arrow in the column header to display a list in which you can make filter choices.

4. To select by values, in the list, clear the (Select All) check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results.