In this tutorial, you will learn how to filter a column by multiple values in Excel.
The Filter function in Excel makes it simple to remove a specific value from a column, but there are times when you may need to remove multiple values from a lengthy column, as shown in the screenshot below. The most effective method of filtering might not be to check each item in turn in the lengthy Filter list box. In this article, I’ll discuss a few expedient solutions to this problem.
Once you are ready, we can start by using real-life scenarios to help you understand how to filter a column by multiple values in Excel.
Table of Contents
Filter a Column by Multiple Values
Before we begin we will need a group of data to be used to filter a column by multiple values in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we will filter ‘Red’ and ‘Blue’. First, we need to select the entire data group, then select ‘Advanced’. Then select the ‘Criteria range’.
Step 3
Once we are done, you will be able to filter the specific criterias.
