To filter Excel rows for cells containing particular text, select a cell in your data, choose Data > Filter, open the column’s dropdown, then choose Text Filters > Contains and enter the word or phrase. For a quick search, type text into the dropdown’s search box and select the matching values; either method hides rows that do not match without deleting them.
How Excel’s text filter works
Excel’s filter acts on rows in a range or table. When you apply a condition to a column, Excel displays rows whose cells meet that condition and temporarily hides the others. For example, if a Support column contains “Open,” “Waiting,” and “Closed,” a Contains filter for “open” displays rows with that text, including a cell such as “Open – assigned to Lee.” The spelling and capitalization can vary because standard text filters are not case-sensitive.
“Contains” means the search text can appear anywhere in the cell. It is different from “Equals,” which looks for a cell whose value matches the criterion rather than merely including it as part of a longer value. This distinction matters when cells contain phrases, labels, ticket descriptions, or codes with prefixes and suffixes.
Filtering changes what is visible, not the underlying values. Clear the filter to show the hidden rows again. This makes filtering useful for reviewing a subset of a list, but it is not a way to remove unwanted records permanently.
Use Text Filters > Contains
For a clear contains condition, use the Text Filters menu. These steps apply to Excel for Microsoft 365 on Windows:
- Make sure the data has one header row, with a distinct heading above the column you want to search. Remove completely blank rows or columns that could split the data into separate regions.
- Select a cell inside the data. On the Data tab, choose Filter. Excel adds dropdown arrows to the header row. If your data is formatted as an Excel table, filter arrows are normally already available.
- Open the dropdown arrow for the relevant column, point to Text Filters, and choose Contains.
- Enter the word or phrase in the dialog box. If the dialog offers a second condition, leave it unused unless you want to combine criteria.
- Choose OK. Excel shows the rows that satisfy the condition and hides the remaining rows.
For example, a Contains condition for “north” can match “North region,” “Office – North,” and “northeast.” If you only want the first two types, “north” is too broad: consider a more distinctive phrase or use a second condition. A contains filter searches the cell’s text, not the meaning of the words, so it cannot tell whether a match is relevant to your purpose.
On Excel for Mac, the same basic Data > Filter and column-dropdown workflow is available, although the ribbon layout and dialog presentation can differ. In Excel for the web, use the Data tab and the column dropdown; the core Text Filters options work similarly. If a command is not visible in a compact window, expand the ribbon or look in the dropdown rather than assuming the feature is unavailable.
Search from the column dropdown
The dropdown search box is often quicker when you want to show one or more existing cell values. Open the column arrow, type a word into Search, and Excel narrows the checklist to values that match the search. Select the values to keep visible, then choose OK. This approach is particularly convenient when the column contains repeated categories such as “Needs review,” “Ready,” and “Waiting.”
There is a useful difference between this checklist search and a Text Filters condition. The search box helps locate values in the list so you can select them; it does not necessarily mean you have defined a reusable contains rule. If you want every row whose cell includes a phrase, including longer variations of that phrase, use Text Filters > Contains. If you want only particular complete values, choose those values from the checklist.
When the dropdown shows many distinct values, the checklist can be cumbersome. Searching narrows the visible choices, but confirm which boxes are selected before applying the filter. Also check whether Select All is on or off: selecting a value while other values remain selected may leave more rows visible than expected.
Filter for more than one word or condition
Text Filters can combine two conditions for the same column. In the Custom AutoFilter dialog, choose whether the conditions are joined by “And” or “Or.” Use And when both conditions must be true, such as a cell that contains “invoice” and also contains “overdue.” Use Or when either is enough, such as a cell that contains “urgent” or “escalated.”
Think carefully about what “And” means for phrases in one cell: both terms must occur in that cell, but the condition does not require them to be adjacent or in a particular order. If the requirement is a specific phrase, type that phrase as one contains criterion instead. Test the result against a few known rows, especially if your list uses abbreviations or inconsistent wording.
Filters on different columns combine as well. For example, filtering Status to contain “Open” and Region to contain “West” shows rows that meet both column filters. That is an AND relationship between columns. To see different regions for the same status, select multiple region values in the Region checklist or construct the appropriate OR condition within that column.
Wildcards, punctuation, and exact matches
Excel’s AutoFilter criteria support wildcard characters in text criteria. An asterisk (*) stands for any number of characters, and a question mark (?) stands for one character. A tilde (~) escapes a wildcard when you need to search for it literally. For instance, a criterion built around “report*” can match text beginning with “report” followed by other characters, while “?at” can match three-character text ending in “at.”
Wildcards are useful for predictable patterns, but a regular Contains condition is simpler for most searches. If you are looking for a literal asterisk or question mark in data, wildcard interpretation can cause surprising matches; use the tilde escape where the filter criterion supports wildcard matching, then verify the visible rows. Punctuation such as hyphens, spaces, and apostrophes is part of the text, so a phrase that includes it may not match a differently formatted version.
To find a whole cell value rather than a substring, use Text Filters > Equals. For example, Contains “cat” can match “cat,” “catalog,” and “black cat,” while Equals “cat” is intended for the value “cat.” If the column mixes numbers and text, note that Excel may present Number Filters for numeric cells and Text Filters for text. A number stored as text may behave differently from the same digits stored as a number.
Use a formula when you need a separate result list
A normal filter hides rows in place. If you need a separate, updating list of matching records, the FILTER function can return those records in another area. This function is available in Microsoft 365 and Excel 2021 or later; it is not available in every older Excel release.
Assume A1:C6 contains headers in row 1, the text to search is in B2:B6, and the complete records are in A2:C6. If those five text values are “Urgent: call supplier,” “Routine check,” “Not urgent – review,” “URGENT: renew,” and “Closed,” enter this formula in an empty cell:
=FILTER(A2:C6,ISNUMBER(SEARCH("urgent",B2:B6)),"No matches")
SEARCH looks for “urgent” within each cell without regard to capitalization, and ISNUMBER identifies the positions where it was found. FILTER returns the corresponding full rows. In this example, the result includes rows 2, 4, and 5 of the source data: “Urgent: call supplier,” “Not urgent – review,” and “URGENT: renew.” The “Not urgent” row is included because it contains the search text; if that is not wanted, choose a more specific criterion or add suitable logic. The result spills into neighboring cells, so keep the output area clear.
This formula is a useful alternative when you want to preserve the original view or display matches on a report sheet. It is not identical to clicking a column filter: the formula returns values in a new location and updates as the source data changes, while AutoFilter changes which source rows are shown. For a case-sensitive formula search, Excel’s FIND function is case-sensitive, unlike SEARCH, though a formula using it needs to handle nonmatches appropriately.
Common problems and how to diagnose them
- No rows appear: Check spelling, spaces, punctuation, and whether the cells are stored as text. Clear the filter and inspect a source cell directly. A trailing space or a different hyphen can make an intended phrase differ from the actual content.
- Too many rows appear: Contains deliberately matches partial text. A search for “art,” for example, can match “article” as well as “art.” Try a longer phrase or use Equals if only a complete cell value should match.
- Some rows seem missing: Another column may still have an active filter. Check the dropdown arrows across the header row and clear any conditions that should not apply.
- The filter arrows are missing or cover the wrong area: Select a cell in the data and choose Data > Filter. Confirm that the range has a single header row and no blank row splitting the records. Converting a clean range into a table with Insert > Table can make its boundaries and headers easier to manage.
- The result changes after editing: Reapply or clear and rebuild the filter if needed, and check for newly added rows outside the original filtered range. A table generally expands as adjacent data is added, whereas an ordinary range may need to be extended.
If you want a quick check before relying on a filtered result, compare the visible rows with a few examples you know should match and a few that should not. This catches mistakes such as searching for a short word that appears inside unrelated words.
Frequently Asked Questions
Can Excel filter cells that contain part of a word?
Yes. Choose Text Filters > Contains and enter the letters or phrase. Excel can match that text inside a longer cell value. For a full-cell match instead, use Equals.
Is Excel’s contains filter case-sensitive?
No. Standard AutoFilter text criteria and SEARCH are not case-sensitive. If capitalization must distinguish matches, use a formula-based approach with the case-sensitive FIND function or carefully designed criteria.
Can I filter for two words at once?
Yes. Use the Custom AutoFilter dialog to combine two text conditions with And or Or. And requires both terms in the cell; Or accepts either. If the words must appear as one exact phrase, enter the phrase as a single contains condition.
Does filtering delete the rows that do not match?
No. It hides them from view. Clear the column filter to display them again. If you need to remove records, first make a copy or use a deliberate deletion process rather than assuming filtering has erased anything.
Why does a search for a word show unrelated matches?
Contains searches for a sequence of characters anywhere in the cell. A short search term may appear inside a longer, unrelated word, and a phrase such as “urgent” also appears in “not urgent.” Use more specific wording, an exact-value condition, or additional criteria.
Related
- Excel Custom Number Format with Text: How It Works
- Excel Custom Number Format: Show Zero as a Dash
- Excel Custom Number Format for Millions
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- COUNTIFS in Excel: Exact and Partial Text MatchesYes. In Excel, COUNTIFS can count cells that match text exactly or contain a text fragment: use =COUNTIFS(A2:A100,"Apple")…
- Concat Excel Date Format: Keep Dates ReadableTo concatenate a date in Excel and keep it readable, convert the date to formatted text with TEXT…
- Excel MAX of Two Values: Formula and ExamplesTo find the larger of two values in Excel, use =MAX(A1,B1), replacing A1 and B1 with the cells…
- Excel Round Up to Whole Number: Formulas and ExamplesTo round a value in Excel up to a whole number, use ROUNDUP with zero decimal places. If…
- Date Filter Formula in Excel: Examples and TipsIn Excel for Microsoft 365, use the FILTER function to return rows whose dates meet your criteria. For…
- TEXTJOIN in Excel: Join Text from Arrays and RangesIn Excel, use TEXTJOIN to combine text from a range or array into one cell, with a delimiter…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.