Clear or remove a filter

If you can’t find specific data in a worksheet, it may be hidden by a filter. For example, if you have a column of dates in your worksheet, that column may have a filter that restricts the values to specific months.

There are several options:

  • Clear a filter from a specific column

  • Clear all filters

  • Remove all filters

Clear a filter from a column

Click the Filter Applied filter icon button next to the column heading, and then click Clear Filter from <"Column Name">.

For example, the figure below depicts an example of clearing the filter from the Country column. 

Clear filter from button

Note: You can't remove filters from individual columns. Filters are either on for an entire range, or off. If you don't want someone to filter a particular column, you can consider hiding it.

Clear all the filters in a worksheet

Click the Data tab, and then click Clear.

Clear a filter button

How do I know if the data has been filtered?

If a filtering is applicable to a table in a worksheet, you’ll see either of these buttons in the column heading:



Filter drop-down arrow

A filter is available and it hasn’t been used to sort the data in the column.

Applied filter icon

A filter has been used to filter or sort the data in the column.

In the following worksheet, a filter is available for the Product column, but it hasn’t been used. The filter in the Country column has been used to sort the data.

Filters have been applied

Remove all the filters in a worksheet

If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

See Also

Use AutoFilter to filter your data

Filter a range of data

Sort data in a worksheet

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.