Table of Contents
In Excel, you can filter a column by multiple values by using the advanced filter feature. This allows you to select multiple criteria within a single column and either display only the matching rows or hide the rows that don’t match your criteria. You can also use the AutoFilter feature to filter a column by multiple values, by selecting each value you want to filter by in the drop-down lists for that column. This is an easy way to quickly filter your data and find the information you need.
Often you may want to filter a column by multiple values in Excel.
Fortunately this is easy to do using the Advanced Filter function.
The following example shows how to use this function in practice.
Example: Filter Column by Multiple Values in Excel
Suppose we have the following dataset that contains information about various basketball players:
Now suppose we’d like to filter the dataset to only show rows where the Team column contains Heat or Celtics.
To do so, we can create a column that specifies which teams we’d like to filter for:
Then, click the Data tab along the top ribbon and then click the Advanced button within the Sort & Filter group:
In the new window that appears, use A1:C16 as the List range and E1:E3 as the Criteria range:
Once you click OK, the data will automatically be filtered to only show rows where the team name is equal to Heat or Celtics:
In this particular example, we chose to filter the data in-place.
If you’d like the filtered data to appear in a different location, simply check the button next to Copy to another location within the Advanced Filter window.
Cite this article
stats writer (2025). How to Filter a Column by Multiple Values in Excel (Easy Guide). PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-you-filter-a-column-by-multiple-values-in-excel/
stats writer. "How to Filter a Column by Multiple Values in Excel (Easy Guide)." PSYCHOLOGICAL SCALES, 29 Nov. 2025, https://scales.arabpsychology.com/stats/how-do-you-filter-a-column-by-multiple-values-in-excel/.
stats writer. "How to Filter a Column by Multiple Values in Excel (Easy Guide)." PSYCHOLOGICAL SCALES, 2025. https://scales.arabpsychology.com/stats/how-do-you-filter-a-column-by-multiple-values-in-excel/.
stats writer (2025) 'How to Filter a Column by Multiple Values in Excel (Easy Guide)', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-you-filter-a-column-by-multiple-values-in-excel/.
[1] stats writer, "How to Filter a Column by Multiple Values in Excel (Easy Guide)," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, November, 2025.
stats writer. How to Filter a Column by Multiple Values in Excel (Easy Guide). PSYCHOLOGICAL SCALES. 2025;vol(issue):pages.