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
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.
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.
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.