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