How to Filter Multiple Search Values in Excel for Mac Without Losing Selections
Question details
The user wants to filter for multiple specific names in an Excel spreadsheet without the search function clearing previously selected items.

- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Filtering a large dataset for multiple specific values simultaneously, without having to manually scroll through the entire filter list.
- Observed behavior
- When using the search box in the filter menu, searching for a new name clears the previously checked names, making it difficult to select multiple items.
Ensure your dataset has clear column headers and no completely blank rows before applying filters or adding helper columns.
Use a Helper Column with an OR Formula
The most efficient way to filter for multiple specific values without manual scrolling is to use a helper column that checks for all your desired criteria at once.
By creating a helper column, you can use a logical formula to flag all rows containing any of your target names. This avoids the limitations of the built-in search filter box clearing previous selections.
Insert a new column next to your data and label it 'Filter Helper' or similar.
In the first data row of the new column, enter an OR formula targeting your criteria. For example, if names are in column A, type: =OR(A2="Albert", A2="George", A2="Quellan", A2="Zelda").
Drag the fill handle (the small square at the bottom right of the cell) down to apply this formula to the rest of the rows in your dataset.
Click on the 'Data' tab and select 'Filter'. Click the filter drop-down arrow on your new helper column and check only the 'TRUE' option.

Filter Multiple Values Effortlessly with WPS Office
WPS Spreadsheet provides powerful and intuitive data filtering options. You can easily set multiple custom criteria without losing your selections or relying on complex formulas.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document containing the data you want to filter.
- 2. Access Custom AutoFilter: Select your header row, go to the 'Data' tab, and click 'AutoFilter'. Click the drop-down arrow on your target column, select 'Text Filters', and choose 'Custom AutoFilter'.
- 3. Set multiple criteria: In the Custom AutoFilter dialog, you can add multiple 'Contains' or 'Equals' conditions joined by 'Or' to filter multiple specific names simultaneously.
- 4. Apply the filter: Click 'OK' to instantly filter your data based on all the selected values without losing any previous criteria.

Frequently Asked Questions
Is there a built-in 'Add current selection to filter' option in Excel for Mac?
Depending on your specific version of Excel for Mac, the 'Add current selection to filter' checkbox might be missing in the search filter menu, which is why the helper column workaround is often necessary.
Can I use Advanced Filter instead of a helper column?
Yes, you can use the Advanced Filter feature under the Data tab. You will need to set up a separate criteria range on your worksheet listing the exact column header and the specific names underneath it.
What if I have dozens of names to filter?
If your list of names is very long, typing them into an OR formula becomes tedious. Instead, use the VLOOKUP or MATCH function in your helper column to compare your dataset against a separate list of desired names.
Will saving the file in WPS Spreadsheet keep my filters intact?
Yes. WPS Spreadsheet is fully compatible with Excel (.xlsx) files. Any filters, helper columns, or formulas you create will be preserved seamlessly when you save the document.




