Excel offers a very interesting way to filter multiple values. We can cater to this problem statement by using the filter option. We can perform the below mentioned way to filter multiple values in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a column with numbers
– Open the desired Excel workbook which contains a column populated with some numbers
Step 2 – Exploring the Filter option
– Now click on any cell in the column, and then under the “Data” section, click on the “Filter” option. This will create a filter drop down in the first cell on the column.
Step 3 – Select multiple values in the filter option
– Now click on the drop down option on top of the column, and then in the new dialogue box select multiple filters and then click “OK”.
Step 4 – Multiple values filtered
– We can see that multiple values have been filtered