Reset Filters back to ALL

I have a worksheet with filters, in all columns (B-AF) with the exception of Col. A. Depending upon which meeting I attend, some columns get filtered while others are left alone (e.g. the filter is kept at Select All). I then have to go into each column and reset it back to Select All, but oftentimes I forget what has actually been filtered.

Is there a quick way to reset all the filters back to (Select All)? Thank You!!

Excel 2010

Outside of a macro, you can do this on the quick access toolbar with the clear command.

http://office.microsoft.com/en-us/he...001234105.aspx

http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

Did you try it?

The word command shows "Clear", but what it does is resets the filters to all.

Do you want to use a macro?

If not, press ctrl + shift + L twice

Sub ResetFilter()
    If ActiveSheet.FilterMode = True Then
        ActiveSheet.ShowAllData
    End If
End Sub

Highlight macro to copy >> Ctrl + C >> Open your workbook
Alt + F11 >> opens the Visual Basic Editor (VBE)
Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
Paste code >> Ctrl + V (right side of screen)
Alt + Q >> exits VBE and returns to Excel
Back in Excel to run the macro >> Alt + F8 >> Macro Dialog Box >> Highlight ResetFilter >> Run

You can even establish your own shortcut key if you wish.

You are very welcome. Glad it worked out for you and thanks for the feedback

Wishing you a happy and safe weekend also...

-----------------------------------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save