Filter worksheets by multiple values

To filter a worksheet by multiple values:

1. In a worksheet, select Filters.

2. In the Filters slide-out panel, from the Field dropdown, select the field that you want to filter in a worksheet.

3. From the Operator dropdown, select List.

4. 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.

5. Select Add Filter.

You can further lock, update, or delete a filter. For more information about personalized worksheet filters, read Enable personalized filters.