200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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