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**:

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Sum Filtered Rows in Excel

How to Delete Filtered Rows in Excel