Microsoft Excel 2007: Reapply or Clear a Filter

Archived Historical Data: Not Actively Maintained.

[Return to Microsoft Office 2007: LSU Overview]

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 Re-apply a Filter or Sort:

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.

Screenshot of reapply under sort and filter

To Clear a Filter:

1. In a filtered range, click the Filter button.

2. Click Clear Filter from <Column Name>.

Screenshot of clear filter

To Clear All Filter Data from the Workbook:

1. Activate the Home tab.

2. Click Sort & Filter in the Editing group.

3. Click Clear.

Referenced from:

5/20/2015 10:58:37 AM  

We love feedback! Please help us improve this article.

Article Rating:
Email Address:
(Optional, unless you would like to hear back from us)
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!
"" ""

Information Technology Services
200 Frey Computing Center · Baton Rouge, LA 70803
Telephone: 225-578-3700 · Fax: 225-578-6400 · E-mail:

Copyright © 2006. All Rights Reserved. Official Webpage of Louisiana State University.