, , ,

How To: Remove a Filter in Data in Microsoft Office Excel

microsoft office excel word power-point

Want create site? Find Free WordPress Themes and plugins.
If you can’t find the data you’re looking for in a worksheet, it might be hidden by a filter. For example, if you have a column of dates in your worksheet, it might be filtered to show only certain months. You can remove a filter from a specific column or get rid of all of the filters in a worksheet at once.
Find more Tips about Microsoft Office Excel Here.

Remove a filter from a column

  • Click the Filter Applied filter icon button next to the column heading, and then click Clear Filter from <“Column Name”>.

Clear filter from button

Remove all the filters in a worksheet

  • Click the Data tab, and then click Clear.

Clear a filter button

How do I know if the data has been filtered?

If a filter is available, you’ll see one of the following buttons next to the column heading:

Filter drop-down arrow This button means a filter is available and it hasn’t been used to sort the data in the column.

Applied filter icon This button means a filter has been used to filter or sort the data in the column.

In the following worksheet, a filter is available for the Product column, but it hasn’t been used. The filter in the Country column has been used to sort the data.

Filters have been applied

Find more Tips about Microsoft Office Excel Here.


Don’t forget to like us on Facebook and Google+ as well as share this to your social networks to support us.

Please comment below if you have any query.

Did you find apk for android? You can find new Free Android Games and apps.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.