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

Was this article helpful?
0 out of 0 found this helpful

Get Additional Help

Visit our Helpdesk for additional help and support.

Powered by Zendesk