How To Use Filter In Excel?

Select the data range or click any cell inside the table

Go to the Data tab

Click Filter

Use the drop-down arrows in the column headers

Select or clear items to show or hide rows

Use text, number, or date filters for specific conditions

Click OK to apply the filter

Clear the filter from the drop-down menu or use Data > Clear

Turn off Filter by clicking Filter again on the Data tab

Suggested for You

Trending Today