How to Filter Multiple Values in Excel: A Practical Guide

Formulas & functions · Updated November 20, 2026

To filter for several values in one Excel column, open its filter dropdown, clear (Select All), check each value you want to keep, and select OK. Excel shows rows matching any selected value. You can also filter another column to narrow those results further. These steps are for Excel for Microsoft 365 on Windows; the same basic dropdown method is available on Mac and in Excel for the web, though some menu details differ.

What You’ll Need

  • A worksheet with a single header row and a consistent data table. Each column should have one type of information, such as department, status, or date.
  • Excel for Microsoft 365, or a version of Excel with the regular AutoFilter feature. You do not need a formula or add-in for the standard method.
  • Optional: the exact values you plan to select, especially if the column contains many entries or similar-looking labels.

Step-by-Step

  1. Check and prepare the data. Make sure every column has a unique header, there are no completely blank rows splitting the dataset, and each row represents one record. For example, a sales list might have headers for Date, Region, Product, and Amount. Remove or fill blank headers before turning on filters; a blank line in the middle can cause Excel to detect only part of the list.
  2. Select a cell in the data. Click any cell inside the range you want to filter. You usually do not need to select the entire worksheet or highlight every row. If the data is surrounded by unrelated content, select just the data range, including its headers, so Excel does not add other cells to the filter.
  3. Turn on the filter arrows. On the Windows ribbon, choose Data > Filter. Excel adds a dropdown arrow to each detected header. You can also use Ctrl+Shift+L on Windows to toggle AutoFilter. On a Mac, choose Data > Filter if the shortcut differs in your Excel setup; in Excel for the web, use the Data tab’s Filter command.
  4. Open the dropdown for the column to filter. Select the arrow beside the relevant header—for example, the arrow beside Region if you want to keep several regions. The menu displays available values and usually includes a search box, sorting commands, and filtering options. If the dropdown is missing, confirm that filters are on and that you clicked a header within the filtered range.
  5. Clear the current selection. In the list of values, uncheck (Select All). This clears the checkboxes so you can choose only the items you need. If you want to keep nearly every value and remove just one or two, it may be quicker to leave all selected and uncheck only those unwanted values.
  6. Select every value to include. Check the box beside each required entry, such as East, Central, and West. The selection is inclusive: rows showing any checked value in that column remain visible. If the list is long, use the dropdown’s search box to find an entry, check it, clear the search, and locate the next entry. Review the checked items before applying the filter.
  7. Apply the selection. Click OK. Excel hides rows that do not match the checked values; it does not delete or move them. The filter arrow normally changes to indicate that a filter is active. Look at the row numbers as well: skipped numbers are expected because some rows are hidden.
  8. Add a filter in another column if needed. Open a second header dropdown and select the values or conditions you want there. Filters applied to different columns work together: a row must satisfy the filter in each column to remain visible. For instance, selecting East and West in Region, then selecting Open in Status, shows open records from either East or West.

To remove one column’s filter while keeping the others, open that column’s dropdown and choose Clear Filter From followed by the column name, when that command is available. To clear every filter at once, use Data > Clear. This clears the criteria but leaves the filter arrows in place. Choose Data > Filter again if you want to turn the arrows off entirely.

If the dataset will grow, consider converting it to an Excel table first. Select a cell in the range and choose Insert > Table, confirm that My table has headers is checked, and select OK. Tables include filter arrows by default and generally extend the table as you add adjacent rows, making it easier to keep the filter range current.

Common Mistakes

  • Leaving Select All checked. If every value remains checked, the filter may appear to do nothing. Clear the selection first when you want a short list of specific values, then check only those values.
  • Expecting multiple selections to mean AND. When you check multiple entries in one column, Excel keeps rows matching one value or another. Selecting North and South means either region is acceptable. A row cannot have both distinct region values in the same cell. To require conditions on separate columns, filter each column; those column filters combine as AND.
  • Filtering an incomplete range. A blank row or an adjacent block of unrelated data can make Excel detect the wrong boundary. Check that the filter arrows appear on all intended headers and that the full data range is included before trusting the results.
  • Using inconsistent labels. Excel treats entries such as “In Progress,” “In progress,” and “In Progress ” (with a trailing space) as separate text values in the checklist. Standardize labels if you expect them to behave as one category.
  • Mistaking hidden rows for deleted data. Filtering hides nonmatching records; it does not remove them. Avoid copying, deleting, or editing a filtered selection unless you have checked which rows are visible and what the command will affect.

Tips

  • Use the search box to navigate, not to guess. Search for a distinctive part of a long label, check the intended result, then clear the search to locate another value. Before selecting OK, make sure the boxes reflect all the values you intended to retain.
  • Filter on the column that represents the category. If you need several products, filter Product. If you need an amount above a threshold, use the number-filter commands instead of checking dozens of individual amounts. The dropdown’s Number Filters, Text Filters, or Date Filters options offer conditions such as greater than, begins with, or a date range, depending on the column.
  • Keep the headers clear and unique. Names such as Region, Status, and Date make the dropdowns easier to identify. Avoid merged header cells, since they can interfere with selecting or managing a simple filter range.
  • Use a table for regularly updated lists. A table makes the filtered range easier to recognize and usually includes newly added rows when they are entered directly beneath it. If new data is outside the table, resize the table or add the rows to it before filtering.
  • Record the criteria when a result matters. Note which values and columns are selected, particularly when preparing a report. A filtered view can look like the whole dataset even though some records are hidden.

For a more repeatable multi-value filter, Excel’s desktop Advanced Filter can use a criteria range. Put the exact source-column header at the top of a small criteria area and list each allowed value below it, one per row. Those separate rows mean “this value or that value.” To apply it, choose Data > Advanced, set the list range and criteria range, and select OK. The criteria header must match the source header. Advanced Filter is useful for a fixed criteria list or copying results to another location; it is less convenient than the dropdown for quick interactive filtering. It is a desktop Excel feature, so use the dropdown method in Excel for the web.

Troubleshooting

  • The dropdown has no values or does not show all rows. Turn off the filter and inspect the range for blank rows, blank headers, or cells separated from the main list. Select a cell in the intended dataset and choose Data > Filter again, or select the full range first and reapply it. If the source is a table, check that the rows are inside the table boundaries.
  • A value you expect is missing from the checklist. Check for a spelling difference, extra spaces, or a different data type. A number stored as text may not behave like a number, and dates stored as text may not appear in a date grouping. Clear the filter and inspect the original cells; correct inconsistent entries, then reopen the dropdown.
  • The filter shows no matching rows. Reopen the dropdown and confirm that at least one value is checked. Then inspect other filtered columns: because separate column filters combine, a restrictive selection elsewhere can remove every row. Clear filters one at a time to find the condition causing the empty result.
  • New records are not included. The filter may cover only the original range. Clear the filter, extend the range to include the new records, and apply it again. If using a table, confirm that the records were added within the table rather than several rows or columns away.
  • The filter arrows disappeared. Choose Data > Filter to toggle them back on, and check that the active cell is within the data. If the sheet is protected, filtering may be restricted by its protection settings; ask the workbook owner to allow filtering or unprotect the sheet if you are authorized.
  • Other people see a different view. A filter changes the current worksheet view, and shared workbook features or different saved views can affect what collaborators see. Clear the filters and reapply the intended criteria, or tell collaborators which values are selected. In Microsoft 365, Sheet View may be available for working with a personal filter view without changing what others see; availability depends on the workbook location and sharing setup.

Frequently Asked Questions

Can I select several values in one Excel filter?
Yes. Open the column dropdown, clear (Select All), check each value to include, and choose OK. Excel displays rows matching any checked value in that column.

Can I filter multiple columns at the same time?
Yes. Set a filter in each column in turn. A row must meet the selected condition in every filtered column, while multiple checked values within one column are alternatives.

Can I filter for values that are not listed?
Use the dropdown’s search field to locate values in its list. If the value is absent, first check for spelling, spacing, or range-boundary issues. For more flexible conditions, try the column’s Text Filters, Number Filters, or Date Filters menu.

Does filtering delete rows?
No. A filter hides records that do not match. Clear the filter to show them again. If you plan to delete records, clear or inspect the filter first so you understand which rows are visible.

How do I clear a filter without removing the arrows?
Choose Data > Clear to clear active filter criteria while leaving AutoFilter turned on. To remove the arrows as well, choose Data > Filter to switch AutoFilter off.

Can I use the same method in Excel for Mac or the web?
The filter-dropdown checklist works in both, though the interface may be arranged differently. Use the Data tab’s Filter command to show the arrows. For Advanced Filter, use the desktop version of Excel.

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.