How to Remove Filter in Excel

Last Updated: November 05, 2023
puneet-gogia-excel-champs

- Written by Puneet

In Excel, there are multiple ways to remove filters from data. But in this tutorial, we not only learn methods to remove the filter, but we will also learn the difference between removing a filter and clearing it.

Keyboard Shortcut to Remove a Filter

To remove or deactivate a filter from the data, you can use the same shortcut that you use to apply it, and that’s:

Ctrl + Shift + L

Alt > D > F > F

keyboard-shortcut-to-remove-a-filter

Select any of the cells from the data and then use any of the keyboard shortcuts.

Press the Filter Button to Remove the Filter in Excel

You can also use the filter button to remove the filter. When you apply the filter from Data > Filter. The filter button turns ON. And when you want to turn it OFF, you need to click on that button.

filter-button-to-remove-filter

And the moment you click on the button, it removes the filter from the data. This button works like the keyboard shortcut we used in the first method.

Clear Filter Instead of Removing

You can also clear the filter instead of removing the filter. For this, you need to click on the filter drop-down on the column that you have filtered.

clear-filter-instead-of-removing

In the above example, you can see that we have a filter for some values in the “Invoice” column and the option to clear the filter from the column. And when you click it, it clears the filter instead of removing it.