How to Clear or Remove Filters in Microsoft Excel

Clear or Remove Filters in Microsoft Excel


Created at 3 months ago by: Adnan Hussain Category: Learn Microsoft Excel

Clear or Remove filter in Excel

If you can’t find specific data in a worksheet, it may be hidden by a filter. Watch this video to learn how to clear filters in Microsoft Excel.

Diffrent options to Remove Filters in Excel:

There are several options to clear or remove Filter in Microsoft Excel.

1) Clear all the filters in a Excel sheet

Click the Data tab, and then click Clear. It will clear all filters from your entire Excel sheet.

2) Clear a filter from a Specific column

Click the Filter button next to the column heading, and then click Clear Filter from ("Column Name"). For example, the image below an example of clearing the filter from the Class column. 

About Microsoft Excel:

Microsoft Excel is a software program included in the Microsoft Office suite. It is used to create spreadsheets, which are documents in which data is laid out in rows and columns, like a big table. Due to its extreme versatility and power, Excel has become one of the most-used software programs in the business world since its launch in 1985.


Tag Clouds

Excel Learn Microsoft Excel Online
Search
Owner
Adnan Hussain