Reset all filters

You can clear all active filters in all columns in the sort and filter range on the current sheet using one of the following methods:

–On the Home tab, in the Data group, click the arrow to the right of the  Filter button and select Clear filters.

–On the Data tab, click the arrow to the right of the  Filter button and select Clear filters.

You cannot clear all filters in the view mode and when working with a protected sheet that does not have the Filter data option selected in the Allowed actions block.