Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016 Excel 2013

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:

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

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 Communities.

See Also

Use AutoFilter to filter your data

Filter a range of data

Sort data in a worksheet

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.