Microsoft Excel 2007: Reapply or Clear a Filter
Archived Historical Data: Not Actively Maintained.
When working with filters in Excel 2007 over long periods of time, it may become necessary to reapply criteria or clear the filtering command altogether.
To reapply a filter or sort, follow the instructions below:
1. Make sure the active workbook contains Sort or Filter data.
2. Click the Home tab.
3. Click Sort & Filter in the Editing group.
4. Click Reapply.
To clear a filter, follow the instructions below:
1. In a filtered range, click the Filter button 
.
2. Click Clear Filter from <Column Name>.
To clear all filter data from the workbook:
2. Activate the Home tab.
3. Click Sort & Filter in the Editing group.
4. Click Clear.
Referenced from: Office.microsoft.com
1399
6/29/2012 1:55:53 AM
We love feedback! Please help us improve this article.
Article Rating:
GROK is a resource of Louisiana State University developed and maintained with support
of the LSU Student Technology Fee. We love getting feedback from the general
public, but our one on one support efforts are generally dedicated to the LSU community.
Thanks for your understanding!