Remove a filter

If you can’t find the data you’re looking for in a worksheet, it might be hidden by a filter. For example, if you have a column of dates in your worksheet, it might be filtered to show only certain months. You can remove a filter from a specific column or get rid of all of the filters in a worksheet at once.

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

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 filter is available, you’ll see one of the following buttons next to the column heading:

Filter drop-down arrow This button means a filter is available and it hasn’t been used to sort the data in the column.

Applied filter icon This button means 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

More information about filtering and sorting

 
 
Applies to:
Excel 2013