Table of Contents
To filter multiple columns in Excel, you can use the Advanced Filter feature. This feature allows you to select the column you want to filter, choose the criteria you want to use for the filter, and then set an action for how you want the filter to work. You can also use the Filter feature in the Data tab to quickly filter one column at a time. Both of these features make it easy to quickly filter through large amounts of data in Excel.
The easiest way to filter multiple columns in Excel is to use the Advanced Filter function.
The following examples show how to use this function in two different scenarios:
- Filter for rows that meet multiple conditions
- Filter for rows that meet one of multiple conditions
Example 1: Filter for Rows that Meet Multiple Conditions
Suppose we have the following dataset that shows the total sales of certain products in certain regions for a company:
Now suppose we’d like to filter for rows where the Region is East and the Product is A.
To do so, we can define the following range of cells that contains our criteria:
Next, we can click the Data tab and then click the Advanced Filter button:
We’ll choose A1:C17 as the list range and F1:G2 as the criteria range:
Once we click OK, the dataset will be filtered to only show rows where the Region is East and the Product is A:
Example 2: Filter for Rows that Meet One of Multiple Conditions
Suppose we have the following dataset that shows the total sales of certain products in certain regions for a company:
Now suppose we’d like to filter for rows where the Region is East or the Product is A.
To do so, we can define the following range of cells that contains our criteria:
Next, we can click the Data tab and then click the Advanced Filter button.
We’ll choose A1:C17 as the list range and F1:G3 as the criteria range:
Once we click OK, the dataset will be filtered to only show rows where the Region is East or the Product is A:
