Microsoft Office Tutorials and References
In Depth Information
Clearing a filter
Clear all active filters
1 Click a cell in the filtered data range.
2 Click the Data tab.
3 Using the controls in the Sort & Filter group, perform one of the
a Click the Clear button to clear all filters, and leave the filter
b Click the Filter button to clear all filters, and remove the filter