Microsoft Office Tutorials and References
In Depth Information
Creating an advanced filter
Remove an advanced filter
1 Select a cell in the range from which you want to remove the filter.
2 Click the Data tab.
3 In the Sort & Filter group on the ribbon, click Clear.