In Excel, there is an option to clear all the filters in one click? Or you can do the same action by shortcut. Let's see the techniques in this article.
Why it's important to clear filters?
Filters can be very useful in Excel, but they can also be perceived as annoying if they obscure data, take up too much screen space, or require too much effort to set up.
This is why it's also essential to know how to Clear all the Filters in Excel.
How to know if a column is filtered?
You can easily identify filtered columns when you see this icon
Remove the filter in only one column
Removing the filter for a column is very simple
- Click on the filter arrow of your column
- Select the option Clear Filter From the Column name
Clear all the filters
But, when there are many columns filtered, it's difficult to locate all of them.
This is why, to avoid clearing the filter of each column, one by one, you can directly remove all the filters with this option.
- Data
- Sort & Filter
- Clear
Remove all the filters by shortcuts
Another technique is to use the shortcuts Ctrl + Shift + L to clear (or add) the filter options of all the columns.
Other Excel tricks
- Remove Excel Gridlines
- Draw borders with the mouse
- Fill series automatically
- Increase the Size of the formula bar
- Move a cell with the mouse
