What it does
Allows you to apply filter settings (turn on/off, apply filter(s), clear filter(s)) across multiple sheets containing the same AutoFilter range (generally because they are structured identically with the same columns/fields), which is not natively available in Excel.

When to use it
When you want to quickly apply or unapply the same filters across multiple similar sheets.  Often those sheets are from an exported file where different locations, departments, etc. look identical but with different data.

Why to use it
It’s an efficient way to apply the same filtering across multiple sheets, which Excel cannot do natively in one bulk step.

Default shortcut
None

Other Details

• Category: Filter and Sort / Filter
• Difficulty: 3/5
• Usage/frequency: 3/5
• Automation factor: 5/5 (estimated 180 seconds saved each time used)
• Type: Bulk
• Date added: 11/10/2023
• Tags: Filter, bulk, multi, sheets

Related Macros
Filter Picker
Bulk Filter

Other Articles
None

Filter All Sheets – Example File

Prerequisites
There are multiple scenarios this macro can assist with.  See the instructions below for each of them, which have their own prerequisites.

Instructions
Scenario 1: Turn on AutoFilter for multiple sheets

1. Ensure the active sheet has no AutoFilter applied.
2. Select the range for which to apply AutoFilter (2+ cells)
3. Select the multiple sheets to apply for (tip: use the Sheet Action Picker, option E to select all sheets to the end of the file!)
4. Run the Filter All Sheets macro.  This will turn on AutoFilter in the same place for all selected sheets.

Scenario 2: Turn off AutoFilter for multiple sheets

1. Ensure the active sheet has no AutoFilter applied.
2. Select just one cell in the active sheet.
3. Select the multiple sheets to apply for (tip: use the Sheet Action Picker, option E to select all sheets to the end of the file!)
4. Run the Filter All Sheets macro.  This will turn off AutoFilter for all selected sheets.

Scenario 3: Apply filter(s) for multiple sheets

1. Ensure the active sheet has AutoFilter applied and the desired filters in one or more columns are applied.
2. Select the multiple sheets to apply for (tip: use the Sheet Action Picker, option E to select all sheets to the end of the file!)
3. Run the Filter All Sheets macro.  This will apply the same filters for all selected sheets.

Scenario 4: Clear filter(s) for multiple sheets

1. Ensure the active sheet has AutoFilter applied and there are no filters applied in any columns.
2. Select the multiple sheets to apply for (tip: use the Sheet Action Picker, option E to select all sheets to the end of the file!)
3. Run the Filter All Sheets macro.  This will clear all filters for all selected sheets.