You can create a bulk filter on a worksheet or table. You create the filter by pasting a list of values, separated by commas, semicolons, new lines, or tabs, into the bulk filter box. A filter allows you to easily search a large list of values repeatedly.
Your filter can have up to 10k values in it. When you add a filter, the system does not check that the value exists in the data. This allows you to anticipate values that may be added in your filter.
Before you can create a bulk filter, you must have Can edit permission on the table or worksheet. In this example, you will cut and paste values to create a bulk filter. You could also get a list of text values from another application such as an email or cells from an Excel or Google Sheets spreadsheet.
- When viewing a table, select multiple cells by clicking and dragging.
-
Right click and choose Copy to Clipboard.
-
Click the Filters icon in the column header.
-
Click Add values in bulk:
-
Paste the values into the bulk filter box.
- Click Done.