How to Filter Multiple Columns in Excel

Filtering data in Excel is one of the most practical skills for anyone working with spreadsheets — but filtering a single column only gets you so far. When your dataset spans dozens of columns and you need to isolate rows that meet several conditions at once, knowing how to filter multiple columns changes everything.

What "Filtering Multiple Columns" Actually Means

When you apply a filter in Excel, you're telling the spreadsheet to show only rows that match a specific condition — hiding everything else. Filtering multiple columns means stacking those conditions: show me rows where Column A meets Condition 1andColumn B meets Condition 2.

Excel doesn't just filter one column and move on. Each active filter layer works together, narrowing the visible dataset further with every condition you add. The underlying data isn't deleted — it's temporarily hidden until you clear or adjust your filters.

Method 1: AutoFilter (The Standard Approach)

AutoFilter is Excel's built-in, point-and-click filtering system and the most common way to filter multiple columns simultaneously.

To enable AutoFilter:

1. Click anywhere inside your data range
2. Go to the Data tab → click Filter (or press Ctrl + Shift + L)
3. Dropdown arrows appear in your header row

Once enabled, you can open the dropdown on any column and set a condition. Then open a different column's dropdown and set another. Excel applies both filters at once, showing only rows that satisfy every active condition.

What you can filter by:

• Specific values (checkboxes in the dropdown)
• Text filters: contains, begins with, ends with
• Number filters: greater than, between, top 10
• Date filters: this week, last month, before/after a date

Each column's filter operates independently, but the results are cumulative. A blue dropdown arrow indicates a column has an active filter applied — useful for tracking which columns are currently restricting your view.

Method 2: Custom AutoFilter for Layered Conditions 🎯

Within a single column's filter dropdown, you can apply two conditions at once using the Custom AutoFilter dialog. Under Number Filters or Text Filters, choose Custom Filter to set two rules joined by AND or OR.

This is especially useful when you need a range (e.g., values greater than 100 and less than 500) within one column, while simultaneously applying a separate filter to another column.

Method 3: Advanced Filter for Complex, Multi-Column Logic

When AutoFilter reaches its limits — particularly when you need OR logic across different columns — Excel's Advanced Filter is the tool to reach for.

How it works:

1. Set up a criteria range somewhere on your sheet (a separate area with the same headers as your data)
2. Enter your filter conditions beneath those headers
3. Go to Data → Advanced
4. Specify your list range and criteria range
5. Choose to filter in place or copy results to a new location

The key logic rules in Advanced Filter:

• Conditions on the same row = AND logic (all conditions must be true)
• Conditions on different rows = OR logic (either condition can be true)

This makes Advanced Filter far more powerful than AutoFilter for non-standard filtering scenarios — though it requires more setup and a clear understanding of how your criteria range is structured.

Method 4: Using Tables for Persistent, Structured Filtering

Converting your data range to an Excel Table (Ctrl + T) doesn't change filtering behavior directly, but it makes multi-column filtering more manageable. Tables automatically maintain filter dropdowns, expand when new data is added, and make it easier to reference filtered results in formulas using structured references.

For teams sharing a workbook, table-based filtering is generally more stable than filtering a plain range.

Variables That Shape Your Filtering Experience

Not every Excel setup handles multi-column filtering identically. Several factors affect how smoothly this works in practice:

Common Pitfalls When Filtering Multiple Columns

Forgetting filters are still active is the most frequent issue — it's easy to close a file with filters on and return later confused about why data appears missing. Always check for blue dropdown arrows.

Blank rows within your data range can cause AutoFilter to stop recognizing the full dataset. Excel sometimes treats a blank row as the end of the data, leaving rows below it completely unfiltered.

Filtering vs. sorting are often confused. Filtering hides rows; sorting reorders them. You can do both simultaneously, but they serve different purposes and interact with each other in ways that trip up newer users.

When Formulas Become Part of the Picture 📊

For users who need to extract or analyze filtered results — not just view them — functions like SUBTOTAL, AGGREGATE, and (in newer Excel versions) FILTER become relevant. The FILTER function in Microsoft 365 can replicate multi-column filtering logic entirely within a formula, returning a dynamic array of results without touching the original dataset.

Whether the built-in filter tools cover your needs, or whether formula-based filtering makes more sense, depends heavily on what you're trying to do with the filtered data — not just which rows you want to see.

The right approach shifts considerably depending on how complex your conditions are, how often your filtering criteria change, and whether you need the filtered results to feed into other calculations or reports.