Do you know how to remove the filter from one column or all the columns in one click?
Why it's important to remove filters?
While filters can be very useful in Excel, 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 important to know how to Remove Filter in Excel.
Which columns are 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 Column name
Remove all the filters
But, if many columns are filtered, it's not easy to locate the columns with this symbol.
This is why, to avoid removing the filter of each column, one by one, you can directly remove all the filters with this option.
- Sort & Filter
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