Clear or Remove Filters in Microsoft 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.
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.
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.