Thursday, June 30, 2011

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. 


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More