How to Filter Multiple Items in Excel: A Clear Guide

Formulas & functions · Updated November 20, 2026

To filter for several items in Excel, open the filter arrow in the column heading, clear Select All, check each item you want to keep, and select OK. Excel hides rows that do not match, without deleting them. You can also filter more than one column; Excel then shows rows that meet the selected criteria in every filtered column.

The steps below are for Excel for Microsoft 365 on Windows. The same basic dropdown method works in Excel for Mac and Excel for the web, although ribbon layouts can vary slightly. Start with a single, rectangular data range that has one clear header row and no completely blank rows or columns splitting the data.

What You’ll Need

  • An Excel workbook containing the data you want to narrow down.
  • A header row with a separate heading for each field, such as Status, Region, or Product.
  • A general idea of the values you want to include. For example, you might want to show several regions or more than one order status.

Step-by-Step

  1. Check the structure of your data. Make sure every column has a heading and each row represents one record. For example, an order list might have columns for Order ID, Date, Region, and Status. Remove completely blank rows within the list, and avoid merged cells in the header or data. If your worksheet has notes or totals directly beside the list, move them away so Excel can identify the intended range cleanly. You do not need to sort the records first.
  2. Turn on the filter controls. Click a cell inside the data range. On the ribbon, select Data > Filter. Excel adds a dropdown arrow to each heading in the detected range. You can also select Home > Sort & Filter > Filter. In Windows, Ctrl+Shift+L toggles filters on or off. On a Mac, use the Data tab’s Filter command if that shortcut is unavailable or assigned differently. If Excel adds arrows to only part of your list, undo the filter and check that there are no empty rows or columns dividing the data.
  3. Open the dropdown for the column to filter. Select the arrow beside the relevant heading, such as Status. The menu displays values found in that column, along with checkboxes. A checkmark means the value is included; a cleared box means rows with that value will be hidden. Excel may also show sorting commands and, depending on the data type, text, number, or date filter options. Those options are separate from the checklist, so use the checklist when you want to select several specific values.
  4. Select the items to show. In the checklist, clear Select All to uncheck every value. Then check each item you want visible, such as Open, Pending, and On Hold. Select OK to apply the filter. The visible rows will include records whose Status matches any one of the selected values. This is an OR choice within one column: a row can match Open or Pending or On Hold. It does not require a row to match all three values at once.
  5. Use the search box when the list is long. Open the same column dropdown and type a word or part of a value in the search box. Check the matching item, then clear the search text to find another item and check that one too. Repeat until all the values you want are selected, then select OK. Review the checked items before applying the filter. Search helps you locate values in a long checklist; it is not the same as selecting a filter condition such as Begins With. If you need to match a pattern rather than choose known entries, use the text filter commands instead.
  6. Filter additional columns if needed. After filtering Status, open another heading’s dropdown, such as Region, and select one or more regions. Excel combines filters across different columns: a row must meet the Status selection and the Region selection to remain visible. For instance, selecting Open and Pending in Status, then West in Region, shows open or pending orders in the West region. The two-column result is an AND between the column filters, while each checklist can contain multiple values within its own column.
  7. Check the result and change or remove filters. Look for the filter icon in the headings and confirm that the visible records make sense. To change a selection, reopen its dropdown, check or uncheck values, and select OK. To clear a filter from one column while leaving other filters in place, open that column’s dropdown and select Clear Filter From followed by the column name. To show all rows, use Data > Clear. To remove the dropdown arrows entirely, select Data > Filter again. Clearing a filter reveals hidden rows; it does not restore deleted data because filtering does not delete rows.

Common Mistakes

Leaving Select All checked. If every checkbox remains selected, the filter includes every listed value and appears to do nothing. Clear Select All first, then check only the values you need. If you are unsure which values are active, reopen the dropdown and inspect the checkmarks.

Expecting an AND within one checklist. Choosing several entries in a single column includes rows matching any selected entry. It does not mean a cell must equal multiple different values at once. To require multiple conditions, use more than one column or use the column’s custom filter options when they fit your criteria.

Filtering the wrong range. Blank rows, merged headings, or unrelated data immediately beside the list can confuse Excel’s range detection. Check that each record is part of one continuous block and that the dropdowns appear on the correct headings. Converting a clean list to an Excel table can make the data boundary easier to manage.

Assuming hidden rows were removed. A filter temporarily hides nonmatching rows. Copying a range or calculating totals afterward may require care, because hidden records still exist in the worksheet. Do not delete rows simply to make a filtered view; use Clear when you want to see the full list again.

Tips

  • Make the list a table. Click inside the data and select Insert > Table, confirm the range, and make sure My table has headers is selected. Tables include filter arrows in their header row and generally expand when you add adjacent records. Review the proposed range before confirming so unrelated cells are not included.
  • Use exact values for repeatable selections. If the source contains values such as North, North Region, and Northeast, check the full entries rather than assuming that a partial search means an exact match. The dropdown checklist selects distinct values as displayed in the column.
  • Keep a record of the selection logic. When a result will be shared, note which values and columns are filtered. A filtered worksheet can look like a complete dataset even though some rows are hidden. You can also use a clear worksheet title or a nearby note to explain what the view contains.
  • Use custom filters for patterns or ranges. In a text column, choose Text Filters for options such as Contains or Begins With. In a numeric column, choose Number Filters for comparisons such as Greater Than. For dates, the menu offers date-based conditions. These are useful when the desired set is defined by a rule rather than a short list of known checklist entries.
  • Remember the across-column logic. Different column filters narrow the result together. If the result is too small, remove one column filter at a time to see which condition excludes the records. If it is too large, verify that the right items are selected in each column.

Troubleshooting

The filter arrows do not appear. Click inside the list and select Data > Filter. If the command appears unavailable, check whether the worksheet is protected or whether you are editing a cell. Also check that the data has a recognizable header row. If Excel applies arrows to the wrong area, turn Filter off, remove blank separators within the list, select a cell in the intended range, and turn it back on.

A value I expect is missing from the dropdown. First clear filters in the other columns; the visible checklist can be affected by the remaining rows in the current filtered view. Then reopen the dropdown and search again. Check for leading or trailing spaces, spelling differences, and values that are stored differently, such as a date stored as text. If the list has changed since the filter was applied, clear and reapply the filter so the displayed choices refresh.

Rows that should match are hidden. Reopen the relevant dropdown and confirm that every required item has a checkmark. Then inspect filters in every other column: one restrictive filter can hide a row that matches the first column. Also check whether the value contains an extra space or different punctuation. Clearing all filters with Data > Clear is a quick way to confirm that the records still exist.

The filter includes unexpected entries. If you searched for a partial word, you may have selected multiple matching values. Open the checklist and inspect the actual checked entries, or use a text condition such as Equals for a more specific match. If Excel included unrelated rows, turn the filter off and confirm that the selected data range stops at the intended final column and row.

Frequently Asked Questions

Can I select multiple values in one Excel column?

Yes. Open that column’s filter dropdown, clear Select All, check each value to include, and select OK. The results match any selected value in that column.

Can I filter multiple columns at the same time?

Yes. Apply a selection in one column, then apply another in a different column. Excel shows rows that satisfy both column filters, while allowing multiple selected values within each column.

Can I filter for values that are not listed as separate items?

Yes. Use the dropdown’s Text Filters, Number Filters, or date filter options to set a condition such as Contains, Greater Than, or a date period. The available choices depend on the column’s data type.

Does filtering delete rows from my worksheet?

No. Filtering hides rows that do not meet the conditions. Select Data > Clear to show the full list again; the hidden records remain in the worksheet.

Why does my filter show no matching rows?

Check that you selected the intended values and clear filters in other columns. Also look for extra spaces, inconsistent spelling, or data stored as text instead of as a number or date.

Do these steps work in Excel for Mac or the web?

The dropdown checklist works in Excel for Mac and Excel for the web as well. Ribbon placement and keyboard shortcuts can differ, so use the Data tab’s Filter command if the Windows shortcut or exact layout is not available.

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.