Note: You can change line 4 to fit your own filter criteria. Replace the number ‘5’ with the number of the column you want to apply the filter to. That means if you want to apply the filter to column A, you need to change it to “1”. Replace the criterion “Retired” with the Criterion you want the filter to satisfy (for deletion). Also note that if you have more than one criteria, you can repeat this line for each criterion., In this article, you will get 5 easy & quick ways to remove Filter in Excel. By following any of the ways you will be able to remove Filter., In the following worksheet, a filter is available for the Product column, but it hasn’t been used. The filter in the Country column has been used to sort the data. Remove all the filters in a worksheet If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F. Need more help? You can always ask an expert in the Excel Tech .