Excel - Clearing Filters
Excel has the ability to filter data to make it easier to find what you are looking for. When a filter has been applied and the file is saved, the filter remains active until it is cleared. If you open a shared excel file and some data appears to be missing, someone else may have applied a filter. The steps below will help you quickly identify if filters have been applied and how to clear them.
To determine if a filter is applied, look for the following icons in the column heading:
- A drop-down arrow means that filtering is enabled but not applied.
- A Filter button means that a filter is applied.
To clear all filters on a sheet click on the Data tab, in the Sort & Filter group, click on Sort & Filter (just Filter in older versions) then click Clear