Apply Filters Across Sheets


Is there a way to apply filters (Ctrl + shift + L) to more than just one sheet at a time? 

I have tried selecting all tabs and applying the filter dropdowns unsuccessfuly. Doing them manually to each sheet takes quite a bit of time that i'm trying to trim down.




It appears illogical to me that one should want to do what you describe in any but special circumstances. Therefore I do believe that Excel doesn't allow applying the filter to multiple sheets. Since, obviously, you have such a need however the best way of achieving it should be to create a short macro and run it when required. Just record a macro of Shift+Ctl+L and place it in a loop calling up each sheet in turn.


As Variatus said, you can record a macro and post it or tell us what column you want filtered and what to filter it to.  Iterating the worksheets is trivial.  e.g.

Sub AutoFilterAllSheets()
    Dim ws As Worksheet
    On Error Resume Next
    For Each ws In Worksheets
        ws.[A1].CurrentRegion.AutoFilter 3, ">=10"
    Next ws
End Sub

Answer the Question

You must create an account to use the forum. Create an Account or Login