In Excel, if you have multiple columns in the data and you want to filter more than one column, you can do this easily. When you apply a filter to a continuous data range, Excel allows you to filter multiple columns.
In this tutorial, we will look at easy-to-follow steps to apply multi-column filters.
In the above data, we need to apply a filter on two columns “type” and “contributed_by”.
Steps to Apply Multiple Filters in Excel
- First, use the keyboard shortcut (Alt ⇢ D ⇢ F ⇢ F) to apply the filter, or you can also go to the Home ⇢ Sort & Filter ⇢ Filter.
- Next, you need to click on the filter dropdown of the column “type” and from there, you need to untick all the values other than “City”.
- After doing click OK to apply the filter. And when you do this, it will filter the entire data based on the column “City” from the column “type”.
- Next, go to the “contributed_by” column and open the filter dropdown and untick all the values other than the “Kenny Cunanan”.
- In the end, click OK to apply the filter.
Once you do this, you’ll have multiple filters applied to your data. One is in the column “type” and the other is in the column “contributed_by”.
Not just two you can apply multiple filters to as many as columns you want. You can go further and 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.