Search Multiple Values in Excel Filter: A Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To filter a column for several values in Excel for Microsoft 365 on Windows, open its filter dropdown, search for one value and select it, then search for the next value and turn on Add current selection to filter before selecting that result. Repeat for each value and click OK. This keeps rows matching any of your chosen values; the source data is not changed.

The dropdown search is useful when a column contains a long list of distinct entries. You can also select values directly from the checklist, or use a helper column when the list you want to match is long or changes regularly.

What You’ll Need

  • An Excel workbook with a header row and data arranged in columns. Avoid merged cells in the range you plan to filter.
  • The name of the column you want to filter and the values you want to keep. If you plan to use the helper-column option, put the target values in a separate list.
  • Excel for Microsoft 365 on Windows for the menu names below. Excel for Mac and Excel for the web have similar filtering, though some controls can look different or be in a different place.

Step-by-Step

  1. Check your data layout. Make sure the top row has a clear heading for each column, such as Region or Status, and that each row represents one record. Remove blank rows or columns inside the data if they could split the range. If you already use an Excel table, its header row normally has filter arrows and you can go straight to the column you need.

  2. Turn on the filter arrows if needed. Click a cell in the data range, then choose Data > Filter. On Windows, Ctrl+Shift+L also toggles filters on and off. Excel adds a dropdown arrow to each header. If you have a table, use its existing arrow rather than creating a separate filter range.

  3. Open the dropdown for the column you want. Select the arrow in that column’s header, not an arrow in a different field. The dropdown contains a search box and a checklist of values found in the column. Filtering one column affects which rows are displayed, but it does not delete or rearrange the underlying records.

  4. Search for the first value. Click the search box and enter a distinctive word, number, or part of the value. The checklist narrows to matching entries. Search is useful for finding an item in a long list, but it can return partial matches: searching for North, for instance, may show both North and Northeast. Select the checkbox beside the exact entry you want, not every result unless you intend to include them all.

  5. Add the next value without replacing the first. Change the search box to the next value. In the dropdown, look for Add current selection to filter and check it before choosing the new result. This setting tells Excel to add the next selection to the existing filter instead of replacing it. Select the exact matching entry or entries. If you skip this setting, the latest search selection may replace the earlier one.

  6. Repeat for the remaining values. Search for another value, keep Add current selection to filter enabled, and select the entries to include. Continue until every requested value is selected. For example, to show records for North, West, and Central, search and select each of those values. The rows displayed will match North or West or Central in that column.

  7. Apply and check the filter. Click OK in the dropdown. Excel hides rows that do not match the selected values. Check a few visible rows to confirm that each has an intended value in the filtered column. The header arrow usually changes to a filter indicator when a filter is active. If the results are wrong, reopen the dropdown and review the selected checkboxes.

  8. Clear the filter when you are finished. To show all rows again, open the same column dropdown and choose Clear Filter From followed by the column name. You can also use Data > Clear to clear filters across the range. Clearing a filter restores hidden rows; it does not undo edits or remove data.

Alternative for many values: use a helper column. This approach is convenient when you have a large list of values to include or need to repeat the same filter later. Suppose the source values are in A2:A8 and the values to keep are listed in D2:D3. Put a heading such as Match in B1. In B2, enter the formula below, then fill it down through B8:

With source values in A2:A8 and the desired values in D2:D3, enter in B2: =COUNTIF($D$2:$D$3,A2)>0

For example, if A2:A8 contains North, South, East, West, North, Central, and South, and D2:D3 contains North and West, the formula returns TRUE for the North and West rows and FALSE for the others. Filter the Match column to show TRUE. If the list of desired values grows, extend the D range in the formula so it covers the whole list. This checks for whole-cell matches; it does not treat a partial word as a match.

Common Mistakes

Forgetting to add to the current selection. Searching for another value and selecting it can replace the previous choice if Add current selection to filter is not checked. Reopen the dropdown and verify the option each time you search for another group. If the option is missing or difficult to use in your Excel version, select the values directly from the checklist or use the helper-column method.

Selecting every search result instead of the exact value. A search term can match several entries. Searching for West could also show a longer label that includes that word. Inspect the checklist and select only the intended entries.

Filtering the wrong field or range. Confirm that you opened the arrow above the column whose values you want to test. If some records are not included in the filter at all, check for blank rows or separated blocks that may have kept Excel from detecting the full range.

Assuming filters work across columns as OR. Selections within one column keep rows matching any selected value in that column. Filters applied to two different columns usually combine as AND: a row must meet the filter in both columns to remain visible.

Tips

Use distinctive search terms, especially when values share similar beginnings. If a term returns several checklist entries, read the full labels before checking them. For short lists, it may be quicker to scroll the checklist and tick the required values directly rather than searching one at a time.

Keep a separate, clearly labeled list of target values if you use the helper-column formula. It is easier to review and update than a long formula containing many conditions. When working with an Excel table, place the helper formula in a table column so Excel can fill it down for new rows.

Remember that filtering hides nonmatching rows; it does not remove them. Before copying visible results, check that the filter is active on the intended column and that other column filters are not also restricting the displayed records. On Excel for Mac, use Data > Filter to show the filter controls; dropdown layout and shortcut behavior can differ from Windows. Excel for the web also provides column filters, but if you do not see the add-to-selection control, use the checklist or helper-column approach.

Troubleshooting

The result shows only the last value I searched for. Reopen the dropdown. Search for the first value, select it, then search for the next one and check Add current selection to filter before selecting the next result. Repeat for each value and apply the filter. If the option is not available, the helper-column method avoids relying on repeated dropdown searches.

A value I expect is missing from the search results. Clear the search box and inspect the full checklist. Check for extra spaces, spelling differences, or values stored in a different form, such as a number stored as text. Also confirm that the row containing the value belongs to the filtered range and that another active column filter is not hiding it.

The filter returns too many rows. Your search may be finding partial matches. Select only the exact checklist entries you want, then check that no other entries remain selected unintentionally. For a precise whole-cell match against a target list, use the helper formula and filter for TRUE.

The filter arrows are missing or the data seems incomplete. Click inside the data and choose Data > Filter. Check that the range has one header row, no merged headers, and no blank row splitting the records. If Excel added arrows to only part of the data, select the full range, including its headers, and apply the filter again.

Frequently Asked Questions

Can I filter for more than two values in one column?
Yes. Search for each value in the dropdown and add it to the current selection, or tick multiple entries in the checklist. For a very long target list, a helper column is easier to maintain.

Does selecting multiple values show rows that match any value?
Yes. Multiple selected entries in the same column act as OR conditions. A row is kept if its value matches at least one selected entry.

Can I search for partial text and include several matches?
Yes. Search with a shared word or fragment, then check the entries you want from the results. Review each full entry because the search can return more than one match.

Can I filter values from a list in another column?
Yes. Use a helper column with COUNTIF to check whether each source value appears in your separate target list, then filter the helper column for TRUE. Make sure the formula range covers the complete target list.

How do I remove the filter but keep my data?
Open the filtered column dropdown and choose Clear Filter From and its column name, or use Data > Clear. Excel reveals the hidden rows; the filter does not delete them.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.