Excel Filter for Specific Text: Steps and Examples

Formulas & functions · Updated November 19, 2026

To filter Excel rows for specific text in Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the column’s dropdown, and select Text Filters > Contains. Enter the word or phrase and choose OK; Excel hides rows that do not match, without deleting them. Use Equals for an exact cell value, or Begins With and Ends With for text at the start or end.

How Excel’s text filter works

Excel’s AutoFilter adds a dropdown to each header in a selected data range or table. A text filter applies a condition to one column and temporarily hides rows that fail it. The other rows remain in the workbook, and clearing the filter makes them visible again. This is useful for narrowing a large list to entries such as product names containing “blue,” customers whose names start with a letter, or notes containing a particular phrase.

Filtering is different from finding text with Ctrl+F. Find locates matching cells, while a filter shows or hides entire records according to a column condition. It is also different from deleting rows: filtering changes what is displayed, not the underlying data. Copying a filtered range can copy visible rows, so check the selection before pasting or editing if hidden records must not be included.

AutoFilter works best with a rectangular list that has one header row, one record per row, and no completely blank rows or columns inside the list. If the data is already an Excel table, its header dropdowns are normally available. For a plain range, click inside it and choose Data > Filter. Excel generally detects the connected data region; selecting the whole range first can help when nearby cells might be mistaken for part of the list.

Filter for a phrase, exact value, or partial match

Open the dropdown on the column you want to check. In the menu, Text Filters provides conditions such as Equals, Does Not Equal, Begins With, Ends With, Contains, and Does Not Contain. Choose the condition that reflects the question you are asking, enter the criterion, and confirm. For example, Contains with “maple” can show “Maple Street” and “North Maple,” while Equals with “Maple” is intended to show cells whose value is exactly Maple.

Contains is the usual choice when the target may appear anywhere within a longer cell. It is not a whole-word search: a criterion of “art” can match “carton” as well as “art class.” If that distinction matters, use a more specific phrase or an exact-value condition. Begins With is useful for prefixes such as product codes, and Ends With can isolate file extensions or suffixes. These conditions apply to the selected column, not to every column in the row.

The dropdown’s search box is another quick option. Type a word to narrow the list of distinct values shown in the menu, then select the values to keep. This is convenient when you want to choose particular existing entries, but it is not the same as setting a Contains condition: it helps locate values in the checklist, while Text Filters defines a rule. If the same word appears inside many differently named values, use Text Filters > Contains.

Step-by-step: filter a column by text

  1. Make sure the list has clear column headings, such as Customer, Region, and Status. Click inside the list. If it is a plain range, choose Data > Filter to display dropdown arrows.
  2. Open the arrow in the column that contains the text you want to test. For a customer-name example, open Customer; for a status example, open Status.
  3. Choose Text Filters, then select Contains, Equals, Begins With, or the condition that fits. Type the criterion in the dialog. If the menu shows Number Filters instead, Excel may be treating that column as numeric rather than text.
  4. Choose OK and review the visible records. The filter indicator on the column dropdown signals that a filter is active. To remove the condition for just that column, open its dropdown and choose Clear Filter From [column name]. To remove all AutoFilters, use Data > Filter again.

To add filtering to a new range on Windows, Ctrl+Shift+L toggles the filter arrows; on Mac, the equivalent shortcut is Command+Shift+F in current Excel versions. Ribbon commands are easier to verify if a shortcut differs in a particular keyboard layout or version. On Excel for the web, the Data tab also provides Filter, and the dropdown-based text conditions are broadly similar, though the layout can differ from desktop Excel.

Wildcards and matching rules

Text filters can use wildcard characters when you need a pattern rather than one fixed phrase. An asterisk (*) represents any number of characters, including none; a question mark (?) represents one character. For example, a criterion such as “pro*” can match values beginning with pro, while “A?7” can match a three-character value whose first character is A and last is 7. Wildcards are most useful for consistent naming patterns, not for finding an arbitrary phrase anywhere in a cell.

A tilde (~) is used to treat a wildcard character literally in AutoFilter criteria. For instance, if a cell contains an actual asterisk and you want to search for that symbol rather than use it as a pattern, prefix it with a tilde. Because the filter dialog and its condition fields can make wildcard behavior less obvious, test the condition on a small range when the literal symbol is important. For an ordinary substring search, Contains is usually clearer than building a wildcard pattern.

Excel’s standard text filtering is not case-sensitive, so a search for east generally matches East and EAST. Leading or trailing spaces can still affect exact matches: “East” and “East ” are not identical cell contents. Data imported from another system may contain nonprinting characters or inconsistent spacing, so a value that looks correct on screen may not behave as expected. Clean or normalize the source data if exact matching is essential.

Combine filters across columns

Filters on different columns work together: a row must satisfy the active condition in each filtered column to remain visible. For example, filtering Region to contain “East” and Status to equal “Open” shows records meeting both conditions. This is an AND relationship between columns. Clear one column’s filter when you want to broaden the results without changing the other condition.

You can also set two conditions within one column using the Custom AutoFilter dialog. For example, a text column can be set to contain “urgent” OR contain “priority” to show either kind of note. Choosing AND instead would keep only values satisfying both conditions. This can be useful for alternate terms, but remember that one cell has to meet the conditions; it does not search across separate columns. For more complex logic, such as several OR groups across multiple fields, a helper column or Advanced Filter may be easier to audit.

Use a formula for a live filtered result

When you want matching rows displayed in a separate area and updated as source values change, the FILTER function is an alternative to hiding rows with AutoFilter. FILTER is available in Microsoft 365 and Excel 2021 or later. It returns a dynamic array that spills into nearby cells, so leave enough empty space for the results. Unlike an AutoFilter, it does not change which source rows are visible.

Assume A1:C6 contains headers in row 1 and five records in rows 2:6, with order IDs in column A, regions in B, and items in C. If the region entries are East, West, Northeast, East, and South, enter this formula in an empty cell outside the source range:

=FILTER(A2:C6,ISNUMBER(SEARCH("east",B2:B6)),"No matches")

SEARCH finds “east” anywhere in each region value without distinguishing capitalization; ISNUMBER turns successful searches into TRUE values for FILTER. In this example, the result contains three records: the two East rows and the Northeast row. The optional final argument displays No matches if no row qualifies. To require an exact region value instead, change the inclusion test to B2:B6=”East”; that returns only the two rows whose region is exactly East. Keep the formula’s source and test ranges the same height, or Excel can return a size-mismatch error.

Common filtering problems and fixes

  • The filter arrow is missing: Click in the list and choose Data > Filter. Check that the header row is included and that the range is not broken into separate blocks by blank rows or columns. Converting the list to a table with Insert > Table can make its boundaries and headers clearer.
  • The expected rows do not appear: Confirm that you applied the filter to the right column and chose the right condition. Contains finds a substring; Equals asks for a complete value. Also check for leading spaces, spelling differences, punctuation, or nonprinting characters.
  • Text Filters is not available: Excel chooses filter options based on the column’s contents. A column containing numbers may offer Number Filters. Codes with leading zeros, such as 0042, should generally be stored as text if those zeros are meaningful; changing a numeric display format is not always the same as changing the stored value.
  • New rows are not included: A plain filtered range may not expand as expected when records are added outside its boundaries. Add the rows within the range or use an Excel table, which normally extends to include entries added directly below it.
  • Some rows seem to vanish unexpectedly: Another column may still have an active filter, or rows may be hidden manually. Use Data > Clear to clear active filters, then inspect the list. Clearing filters does not unhide rows hidden by other means.

AutoFilter, Advanced Filter, or a formula?

Use the ordinary dropdown filter for quick exploration, selecting known values, or applying straightforward text rules to a working list. It is familiar, reversible, and keeps the source data in place. Use a formula when results should appear separately and recalculate as data changes, or when those results feed another part of a workbook. Dynamic-array formulas are especially useful for building a live report, but require a compatible Excel version and room for the spill range.

Advanced Filter is a desktop Excel option for criteria that are more complicated than a standard dropdown rule, and it can copy matching records to another location. Its criteria range needs headings that match the source columns, with criteria arranged to express the desired AND/OR logic. That setup is powerful but easier to misconfigure than a simple Contains filter. For repeatable reporting with many transformations or multiple sources, Power Query may be a better fit; it is designed to import and reshape data, rather than act as a quick on-sheet filter.

Frequently Asked Questions

Can Excel filter cells that contain a specific word?
Yes. Open the column dropdown, choose Text Filters > Contains, enter the word, and choose OK. The condition can match the word as part of a longer cell value, not only as a separate whole word.

How do I filter for exact text in Excel?
Choose Text Filters > Equals and enter the complete value. Check for extra spaces or punctuation if a value that looks identical is omitted. Excel text filtering is not case-sensitive.

Can I filter for text in more than one column?
Yes. Apply a condition to each column’s dropdown. Conditions across columns are combined so that the row must meet all active filters. Use the Custom AutoFilter dialog to choose AND or OR between two conditions in a single column.

Does filtering delete rows from my spreadsheet?
No. AutoFilter hides rows that do not meet the criteria; it does not remove their contents. Clear the filter to show them again. Take care when copying or editing filtered data, because hidden rows may not be part of the visible selection.

How do I filter text in Excel for Mac or Excel for the web?
On Mac, select the list and use Data > Filter, then use the column dropdown’s text conditions; ribbon placement and shortcuts can vary by release. In Excel for the web, use the Data tab’s Filter command and the dropdown menus. The core distinction between Contains and Equals is the same.

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.