Select a cell in your data and press Ctrl + Shift + L, or go to Data ? Filter. Open the arrow on the first column and pick the values to keep, then open the arrow on the next column and do the same. Each new filter narrows the rows already showing, so only rows that match every column stay visible.
To keep several values in one column, tick more than one box in its list. For a rule, such as names that contain “son” or amounts over $1,000, use Text Filters or Number Filters in the same dropdown.
Filters on different columns always combine with AND. To show rows that match one column OR another, use Data ? Advanced with a criteria range that puts each condition on its own row. In Excel 365 or 2021 you can use the FILTER function instead: =FILTER(A2:D100, (B2:B100="Chicago") + (C2:C100="West")). The + means OR, and * means AND.
A sheet can have only one set of filter arrows. To filter two separate lists on the same sheet, turn each into a table with Ctrl + T, and each table gets its own filters. Clear every filter at once with Data ? Clear.
If you turn filters on from a single cell, Excel stops the filter range at the first blank row, so rows below it are never filtered. Select the whole range first, or use a table. SUM also still counts hidden rows, so use =SUBTOTAL(109, D2:D100) to total only the visible ones.
Let’s say you work in a government agency where you need to quickly assess the impact of different types of services across various states based on population size.
Your Excel sheet contains columns for agency, state, type, population, and contributions. Now, to analyze this data, you can filter multiple columns at the same time. Yes, that’s right. When you apply a filter to a continuous data range, Excel allows you to filter multiple columns.

In the above data, we must filter the “type” and “contributed_by” columns. This is easy when the data has multiple columns and you want to filter more than one column (two, three, or more). This tutorial will look at easy-to-follow steps for this.
Steps to Filter Multiple Columns Simultaneously in Excel
- Select the range of data you want to filter: First, select the range or the table where you have the data on which you want to filter multiple columns. You can also click on the header of the first column, hold the Shift key, and then click on the header of the last column to select the entire range of columns.
- Apply Filter: Use the keyboard shortcut (Alt ⇢ D ⇢ F ⇢ F) to apply the filter, or press Ctrl + Shift + L. You can also go to Home ⇢ Sort & Filter ⇢ Filter (or Data ⇢ Filter).

- Open Filter: Next, click on the filter arrow button in the column “type,” and then untick all the values other than “City.”

- Apply Filter to the First Column: After doing this, click OK to apply the filter. This will filter the entire data to show only the rows with the value “City” in the column “type.”

- Apply Filter to the Second Column: Next, go to the “contributed_by” column, open the filter dropdown, and untick all the values other than “Kenny Cunanan”. Click OK.

Once you do this, multiple filters will be applied to your data. One is in the column “type” and the other is in the column “contributed_by”.

You can apply multiple filters to as many columns as you want, not just two. You can apply one more filter to the column “state”.

In the above example, we have the third filter on the column “state”, where we have filtered all the values with CA. Excel offers a variety of filters that you can use to analyze your data, regardless of the number of columns you have.
- Number Filters: When your column contains numerical data, number filters can be your best ally. They allow you to filter data based on a variety of conditions, such as “equal to,” “greater than,” “less than,” “between,” and more. This is helpful when analyzing data within a certain numerical range or meeting a specific numerical condition.
- Text Filters: This type of filter is useful when working with columns that contain textual data. Text filters allow you to sift through and present your data more meaningfully. You can filter for exact matches and partial matches and even use operators like “begins with,” “ends with,” and “contains.” This is especially handy when you want to isolate data that shares a common text attribute.
- Date Filters: Date filters come into play when dealing with columns containing dates. They provide a simple way to filter your data based on a specific period, such as a particular date, week, month, quarter, or year.
- Color Filters: Color filters can be extremely useful if you’ve assigned colors to your cells based on certain conditions using conditional formatting. They allow you to filter your data based on those colors.
How Multiple Filters Work Together
When you filter more than one column, Excel shows only the rows that match all the filters at the same time (AND logic). In the example above, a row shows only when the type is “City”, the contributor is “Kenny Cunanan” and the state is “CA”. A filtered column shows a funnel icon on its filter button, so you can quickly see which columns have a filter.
To remove the filter from one column, open its drop-down and click Clear Filter From “column name”. To remove all the filters at once but keep the filter buttons, go to Data ⇢ Clear. And to remove the filter buttons as well, press Ctrl + Shift + L again.
Filter Multiple Columns with OR Logic
The filter buttons can’t show rows where one column OR another matches. For that, you have two options. The first is Advanced Filter (Data ⇢ Advanced), where you write each condition on its own row in a criteria range. The second, in Excel 2021 and Microsoft 365, is the FILTER function. The following formula returns the rows where the type (column B) is “City” or the contributor (column E) is “Kenny Cunanan”:
=FILTER(A2:E100,(B2:B100="City")+(E2:E100="Kenny Cunanan"))
In this formula, the plus sign works as OR. Change it to an asterisk (*) to get AND logic, which gives the same result as the filter buttons. Change the ranges and column letters to match your data.
Frequently Asked Questions
The data probably has a fully blank column or row, so Excel applied the filter only to part of the data. Remove the filter, select the whole range (or convert it to a table with Ctrl + T), and apply the filter again.
Can I apply two separate filters on one sheet?
A worksheet can have only one regular filter range. But each Excel table has its own filter, so convert each data set into a table to filter them separately on the same sheet.
Do totals change when I filter multiple columns?
SUM still adds the hidden rows. Use SUBTOTAL or AGGREGATE to total only the rows that are visible after filtering, like this:
=SUBTOTAL(109,D2:D100)