How To Clear Filters In Excel?

Select the filtered range or click anywhere in the table

Go to the Data tab

Click Clear in the Sort & Filter group

Or click the filter drop-down arrow in a column

Choose Clear Filter From [Column Name]

To remove all filters, turn off Filter on the Data tab

If using a table, click the filter arrow and select Clear Filter From All Columns as needed

Suggested for You

Trending Today