Clear Filters

We can clear a filter for a specific column or clear all filters at same time in Excel 2007 and 2010.

Clear a filter for a column

To clear a filter for one column in a multicolumn range of cells or table, click the Filter button Applied filter icon on the column heading, and then click Clear Filter from <"Column Name">.

Clear all filters in a worksheet and redisplay all rows.

On the Data tab, in the Sort & Filter group, click Clear. 

Posted in: Clear Filters,Microsoft Excel 2007,Microsoft Office Support,PCSupport,Technical Support,TechSupp247