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.
More information about filtering and sorting