How To Filter Data In Excel?

Select the data range or click anywhere inside the table

Go to the Data tab

Click Filter

Use the drop-down arrows in the column headers

Check or uncheck values to show or hide specific data

Use Text Filters, Number Filters, or Date Filters for advanced filtering

Click OK to apply the filter

Clear the filter from the same drop-down menu when needed

Use Sort & Filter options for additional filtering tools

Suggested for You

Trending Today