How To Apply Filter In Excel?

Select the data range or click any cell inside the table

Go to the Data tab

Click Filter

Click the drop-down arrow in the column header

Choose the values, text, numbers, or dates you want to show

Click OK

To clear a filter, click the drop-down arrow and select Clear Filter

To remove all filters, go to the Data tab and click Filter again

Suggested for You

Trending Today