How To Excel Filter?

Select the data range

Go to the Data tab

Click Filter

Use the drop-down arrows in the column headers

Check or uncheck values to filter

Use Text Filters, Number Filters, or Date Filters for custom conditions

Click OK to apply the filter

Clear filters from the column drop-down or use Data > Clear

Turn off filters by clicking Filter again

Suggested for You

Trending Today