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 button next to the column heading, and then click Clear Filter from <"Column Name">.
Remove all the filters in a worksheet
Click the Data tab, and then click Clear.
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:
This button means a filter is available and it hasn’t been used to sort the data in the column.
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.