To filter a worksheet by multiple values:
-
In a worksheet, select Filters.
-
In the Filters slide-out panel, from the Field dropdown, select the field that you want to filter in a worksheet.
-
From the Operator dropdown, select List.
-
In the Value field, paste a list of filter values.
Note- The number of characters that you can specify in the Value field is limited to 2,000.
- You must enter each value on a separate line. Do not use commas or other delimiters.
-
Select Add Filter.
You can further lock, update, or delete a filter. For more information about personalized worksheet filters, read Enable personalized filters.