To filter cells by text in Excel for Microsoft 365 on Windows, select your data, choose Data > Filter, open the arrow in the column header, then choose Text Filters > Contains and enter the text. Excel hides rows that do not match; it does not delete them.
How Excel’s text filters work
Excel’s built-in filter is useful when you want to narrow a list temporarily—for example, to show only support tickets mentioning “urgent,” products whose names begin with “pro,” or orders with a particular status. The filter is attached to a column, so first identify which column contains the text you want to test.
After filtering is on, each column heading has a drop-down arrow. The arrow opens two different ways to filter text:
- Text Filters lets you describe a rule, such as Contains, Begins With, Equals, or Does Not Contain. Choose this when you want to match part of a cell or apply a rule consistently.
- The search box and value list lets you find and select distinct values already in the column. Choose this when you want particular entries, such as the exact status “In progress.”
These approaches can look similar, but they answer different questions. Searching the value list finds matching choices in the list of unique cell values; Text Filters checks the contents of each cell against a rule. For example, a value-list search for “urgent” may help select a cell value called “Urgent review,” while Contains can also match “Please mark this urgent today.”
Turn on filtering and apply a Contains rule
For a straightforward filter, include one header row and keep each record on its own row. Avoid blank rows or columns inside the data because they can make Excel interpret the range incorrectly. Then use these steps:
- Click a cell inside the data range. If the data is not a formatted table, check that Excel has identified the whole range and its header row.
- Choose Data > Filter. Drop-down arrows appear beside the column headings. On Windows, Ctrl+Shift+L toggles filtering on or off. In Excel for Mac, Command+Shift+F is the usual shortcut; the Data tab is an alternative.
- Open the arrow for the column you want to check. Choose Text Filters > Contains.
- Type the word or phrase in the dialog box and select OK. Excel displays rows where that column contains the entered text.
To find a word at the start or end of a cell, choose Begins With or Ends With. To match a whole cell value, choose Equals. The available options can vary slightly with the selected column’s data type; if Excel treats the column as numbers or dates, it may show number or date filters instead of text filters.
Choose the right match rule
A “specific text” request can mean several things. Decide whether you need an exact value or a partial match before applying the filter. A cell containing “North Region” is not equal to “North,” but it does contain “North.” That distinction matters when a list mixes short labels with longer descriptions.
- Contains: finds the text anywhere in a cell. Use it for keywords within notes, addresses, or descriptions.
- Equals: matches a complete cell value. Use it for a category or status when the whole entry should be identical.
- Begins With / Ends With: checks the beginning or end of the cell, useful for codes or consistent naming patterns.
- Does Not Contain: excludes rows containing a word or phrase, such as notes that mention “cancelled.”
Excel’s standard text filtering is not case-sensitive: “urgent” can match “Urgent.” It also compares the cell’s text as stored, so an extra space or a spelling variation can cause an expected match to be missed. If the distinction between upper- and lowercase letters matters, the built-in filter is not a case-sensitive test; a formula-based approach is more appropriate.
Combine text conditions
Text Filters can combine two conditions for the same column. For example, a custom filter can show entries that contain “invoice” and “overdue,” or entries that contain “invoice” or “receipt.” In the Custom AutoFilter dialog, enter the first condition, select And or Or, and then enter the second. “And” requires both conditions to be true for the same cell; “Or” accepts either condition.
Use “And” carefully with Contains rules. A cell such as “Overdue invoice” meets both conditions, while a cell containing only “overdue” does not. For more complicated logic—such as combinations across several columns, or a long list of alternative phrases—multiple column filters or a formula may be easier to understand and maintain than a crowded custom-filter dialog.
Excel also supports wildcard characters in filter criteria. An asterisk (*) represents any number of characters, and a question mark (?) represents one character. A tilde (~) can be used to treat a wildcard character as a literal character. Because wildcard interpretation depends on the filter criterion, use the Text Filters dialog for ordinary phrase matching and test wildcard criteria on a small sample if the text itself includes * or ?.
Filter across more than one column
Filters applied to different columns work together: a row remains visible only if it satisfies every active column filter. For instance, filtering a Department column to “Sales” and a Notes column to contain “renewal” shows Sales records whose notes also mention renewal. To broaden the results, use an Or condition within a column where appropriate rather than assuming separate column filters will behave as alternatives.
Filtering changes which rows are visible, not the order or contents of the underlying records. You can still sort a filtered list, but sorting applies to the data range and should preserve each record’s values on the same row. If you need to share a result, tell recipients that the sheet is filtered; otherwise, hidden rows can make the visible list look incomplete. Clear a filter from its column menu with Clear Filter From…, or use Data > Clear to clear filters across the range while leaving filtering available.
Use a formula when you need a separate result list
A normal filter hides nonmatching rows in place. If you want matching records displayed in a separate area, Excel’s FILTER function can return them as a dynamic list. FILTER is available in Microsoft 365 and Excel 2021 or later; it is not available in some older perpetual versions.
Assume A2:C5 contains four records, with item names in column A, owners in B, and notes in C: Printer / Lee / “Urgent: toner”; Laptop / Ana / “Routine”; Router / Sam / “urgent firmware”; and Dock / Kim / “Replace cable.” With those records in A2:C5, this formula returns the complete rows whose notes contain “urgent”:
=FILTER(A2:C5,ISNUMBER(SEARCH("urgent",C2:C5)),"No matches")
The result is the Printer and Router rows—two records—because SEARCH finds “urgent” in both notes and is case-insensitive. The formula returns the original A:C columns, not just the note text. Put it in an empty area with enough room for the results to spill; any occupied cells in the spill area can cause a #SPILL! error. If no row matches, the formula displays “No matches.” Unlike the built-in filter, this result is a separate output and updates when the source data changes.
Common problems and practical fixes
If the expected rows do not appear, first check the filter rule and the source values rather than assuming the data has disappeared. These are common causes:
- The filter covers only part of the list. Clear it, click inside the data, and check that the range includes all rows and columns. Converting a well-structured range to a table with Insert > Table can make the range easier to manage as records are added.
- Text contains extra spaces or inconsistent spelling. “Urgent” and “Urgent ” may look alike but are not identical values. A Contains rule may still match a phrase within a cell, while Equals can fail because of the extra space. Clean inconsistent source data when exact categories matter.
- The wrong column is filtered. Confirm the arrow is in the heading for the field you intend to search. A keyword can appear in a description column but not in a separate status column.
- Excel shows number or date options instead. The column may contain numbers or dates rather than text, or a mixture of types. Check the actual cell values and choose the appropriate filter type.
- Some records appear missing after sorting or filtering. Look for another active filter in a different column. Clear all filters with Data > Clear to restore the full view.
Filtering does not remove rows, but it can affect what you select or copy if you are not aware of hidden records. Before editing or deleting data, clear the filter or verify that the command will affect only the visible rows as intended. For a quick inspection, the status bar and row numbers can help reveal that a list is filtered, but always check the filter arrows when a record seems absent.
Frequently Asked Questions
Can Excel filter cells that contain a word anywhere in the text?
Yes. Open the column’s filter menu and choose Text Filters > Contains, then enter the word. This matches the word wherever it appears in a cell, not just at the beginning.
How do I filter for an exact text value?
Choose Text Filters > Equals and enter the complete value. You can also clear the checkboxes in the value list and select the exact entry, which is convenient for categories that already appear in the column.
Can I filter for two words at once?
Yes. For two conditions in the same column, use the Custom AutoFilter dialog and choose And if both words must occur, or Or if either word is enough. Filters on separate columns are combined as simultaneous requirements.
Does filtering delete the rows that do not match?
No. Excel temporarily hides nonmatching rows. Choose Data > Clear or clear the individual column filter to show them again; the source records remain in the worksheet.
Can I search text in multiple columns at the same time?
Apply a filter to each relevant column to require matches across those columns. If you need to find a phrase in any of several columns, the built-in column filters may not express that as one simple rule; a helper column or a FILTER formula can make the logic clearer.
Related
- Excel Template for Quotation Comparison: Build One
- Excel Task List Template: Set Up and Customize Yours
- Excel Template for a Budget Plan: Build Your Own
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Percent Change CalculationWith the original value in B2 and the new value in C2, enter =(C2-B2)/B2 in D2 to calculate…
- Calculate Age in Weeks in Excel with a Simple FormulaTo calculate completed age in weeks in Excel, put a birth date in A2 and enter =INT((TODAY()-A2)/7) in…
- How to Lock a Filter in Excel Without Losing ControlTo keep an Excel filter in place while protecting the worksheet, set up the filter first, then choose…
- Round Excel Cell Values: Formulas and Display OptionsTo round a number in an Excel cell and change the value used in calculations, use the ROUND…
- COUNTIF Criteria Examples for ExcelIn Excel for Microsoft 365, COUNTIF counts cells in one range that meet one condition: enter the range…
- Excel Sort Entire Row by One Column Without Splitting DataYes. To sort entire rows by one column in Excel for Microsoft 365 on Windows, select the full…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.