Office for Mac Issues

How to Filter Multiple Search Values in Excel for Mac Without Losing Selections

John WilsonJohn Wilson Nov 10, 2026 869 views

Question details

The user wants to filter for multiple specific names in an Excel spreadsheet without the search function clearing previously selected items.

How to Filter Multiple Search Values in Excel for Mac Without Losing Selections
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.
Before you start

Ensure your dataset has clear column headers and no completely blank rows before applying filters or adding helper columns.

Solution 1Recommended

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.

1
Add a new column

Insert a new column next to your data and label it 'Filter Helper' or similar.

2
Enter the OR formula

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").

3
Fill the formula down

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.

4
Apply the filter

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.

Use a Helper Column with an OR Formula
Time Saver: This method is highly scalable. You can add as many conditions as needed inside the OR formula to filter exact matches instantly.
Efficient Filtering in WPS Spreadsheet

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document containing the data you want to filter.
  2. 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. 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. 4. Apply the filter: Click 'OK' to instantly filter your data based on all the selected values without losing any previous criteria.
Advanced filter options for processing multiple criteria easilyFully compatible with Microsoft Excel (.xlsx) formatsLightweight and runs smoothly on Mac, Windows, and LinuxFree to use with a familiar, user-friendly interface
microsoft office alternative - wps office

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.