Office
Sign in

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 two options:

  • Remove a filter from a specific column

  • Remove all of the filters.

Remove 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

Remove 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:

Button

Description

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

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Use AutoFilter to filter your data

Filter a range of data

Sort data in a worksheet

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.

×