Home » Manage data » Remove All Filters in one click in Excel

Remove All Filters in one click in Excel

Reading time: 2 minutes
Last Updated on 19/05/2023 by Frédéric LE GUEN

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

Filter activated in column

Remove the filter in only one column

Removing the filter for a column is very simple

  1. Click on the filter arrow of your column
  2. Select the option Clear Filter From Column name
Remove one filter

Remove all the filters

But, if many columns are filtered, it's not easy to locate the columns with this symbol.

Many columns filtered

This is why, to avoid removing the filter of each column, one by one, you can directly remove all the filters with this option.

  1. Data
  2. Sort & Filter
  3. Clear
Remove filter from the ribbon

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Remove All Filters in one click in Excel

Reading time: 2 minutes
Last Updated on 19/05/2023 by Frédéric LE GUEN

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

Filter activated in column

Remove the filter in only one column

Removing the filter for a column is very simple

  1. Click on the filter arrow of your column
  2. Select the option Clear Filter From Column name
Remove one filter

Remove all the filters

But, if many columns are filtered, it's not easy to locate the columns with this symbol.

Many columns filtered

This is why, to avoid removing the filter of each column, one by one, you can directly remove all the filters with this option.

  1. Data
  2. Sort & Filter
  3. Clear
Remove filter from the ribbon

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

Leave a Reply

Your email address will not be published. Required fields are marked *