How do I select multiple items from a filter in Excel?
(1.) Select Filter the list, in-place option from the Action section; (2.) Then, select the data range that you want to filter in the List range, and specify the list of multiple values you want to filter based on in the Criteria range; (Note: The header name of the filter column and criteria list must be the same.)
Can you have multiple filters in Excel?
If you have a table with multiple columns in Excel, you can filter the data by multiple columns at once.