Excel’s text filters let you show rows whose text matches a condition: choose options such as Equals, Begins With, Contains, or Does Not Contain from a column’s filter menu. To use them in Excel for Microsoft 365 on Windows, select a cell in the data, choose Data > Filter, open the arrow in the text column’s header, then choose Text Filters and a condition.
Where text filters fit
Filtering hides rows that do not meet your chosen conditions; it does not delete those rows or change the underlying cell values. This makes a text filter useful for narrowing a long list of names, product descriptions, locations, status labels, or other text fields while keeping the full dataset available. You can later clear the filter to show the hidden rows again.
Excel’s standard filter is called AutoFilter. It works on a contiguous data range with a header row, or on an Excel table. A table is often convenient because its header controls are built in and new rows added to the table become part of it. For an ordinary range, select a cell within the data and use Data > Filter. Excel adds dropdown arrows to the header cells. If the data has no clear header row, add one before filtering so Excel can identify each field correctly.
On Excel for Mac, the standard filter is also available from Data > Filter; ribbon layout and dialog appearance can vary slightly by release. Excel for the web also offers column filter menus, though the controls may be arranged differently from the Windows desktop version.
The built-in Text Filters options
Open the dropdown for a column containing text and look for Text Filters. Its submenu provides comparison choices. The wording and availability can depend on the values in the column, but the common options are:
- Equals and Does Not Equal: include or exclude a value that matches the criterion, such as the status Open.
- Begins With and Does Not Begin With: match text at the start of a cell, such as product codes beginning with NW.
- Ends With and Does Not End With: match text at the end, such as email addresses ending in a particular domain.
- Contains and Does Not Contain: find a sequence of characters anywhere in the cell, such as rows containing the word urgent.
- Custom Filter: set two text conditions in one dialog and choose whether both conditions must be met or either one can be met.
These options test the contents of one field at a time. For example, a Contains condition on a Notes column can keep rows where a note includes delayed, even if the rest of each note differs. It is not a general search across every column in the worksheet; apply the condition to the column where the relevant information is stored.
Apply a text filter step by step
- Check that the list has one header row and that each column contains one kind of information. Avoid blank rows or columns inside the data block.
- Select a cell in the list, then choose Data > Filter. If the dropdown arrows are already visible, filtering is on.
- Open the arrow in the header of the column you want to search. If the column has many distinct values, use the search box in the menu to locate a value; this is different from setting a Text Filters condition.
- Point to or select Text Filters, then select the condition that fits the question. For example, choose Contains to find descriptions containing cable.
- Enter the comparison text in the dialog and confirm with OK. Excel hides rows that fail the condition and leaves the matching rows visible.
The column dropdown also contains a checklist of individual values. Selecting one or several values there is often the fastest approach when the desired entries are known, such as showing only the categories Books and Music. Use Text Filters when the rule itself matters, particularly when it should match a partial word or a pattern rather than a fixed list of existing values.
Combining conditions and filtering across columns
A Custom Filter can express a small logical rule. Suppose a Description column should show rows containing either repair or replacement. Set the first condition to Contains repair, select Or, and set the second condition to Contains replacement. Choosing And instead would show only cells that satisfy both conditions. That is a much narrower test: a single description would need to include both terms.
Within a column’s checklist, selecting several distinct values generally means show rows matching any selected value. Across separate column filters, Excel combines the active filters: a row must pass the filter in each filtered column. For example, filtering City to contain York and Status to equal Open shows open records in the matching city, not all rows matching either condition. This distinction explains many unexpected results.
AutoFilter’s Custom Filter dialog provides two criteria, which is enough for simple combinations but not a long list of complex rules. For more elaborate conditions, consider Advanced Filter or Power Query, described below. Do not assume that entering two conditions in the dialog creates an unlimited search list; it does not.
Wildcards, capitalization, and exactness
Text criteria can use wildcard characters. An asterisk (*) represents any number of characters, including none; a question mark (?) represents one character. For example, a criterion such as Jo* can match text beginning with Jo, including Jordan and Jo. A pattern such as ??-7 represents two characters followed by a hyphen and 7. The available Text Filters choices already provide common pattern-style tests, but wildcards can be useful when specifying a more particular match.
To search for a literal asterisk, question mark, or tilde rather than use it as a wildcard, precede it with a tilde. For instance, ~* means a literal asterisk. Tilde is the escape character for these wildcard searches. If a criterion seems broader than intended, check whether a wildcard in the text is being interpreted as a pattern.
Standard Excel AutoFilter text matching is not case-sensitive: a criterion for north can match North. It does, however, distinguish different characters and spaces. A trailing space after a word can make a cell different from the same word without the space, and nonprinting characters copied from another system can make matching confusing. Text filters are therefore not a substitute for cleaning inconsistent source data when exact consistency matters.
Text filters compared with value selection and number filters
Use the checklist when the values you want are already present and you can identify them directly. Use Text Filters when you want a rule such as contains, starts with, or does not end with. If Excel recognizes a column as numeric or as dates rather than text, its menu may show Number Filters or Date Filters instead. A column containing a mixture of text, numbers, and dates can produce confusing menus or inconsistent behavior, so keep each column’s data type consistent where possible.
A text filter is also different from Find. Find locates matching content and moves between occurrences; it does not create a filtered view of the records. Likewise, sorting changes row order, while filtering hides rows that do not meet a condition. These commands can be used together, but they solve different tasks.
Common problems and how to fix them
- The filter arrow is missing: select a cell in the data and choose Data > Filter. If the data is a table, check its header row. On Windows, Ctrl+Shift+L toggles AutoFilter on or off; on Mac, use the ribbon command if that shortcut is not assigned in your Excel version.
- Rows that should match are hidden: check filters in every column, because several active filters work together. Open each relevant dropdown and clear a condition that should not apply.
- A Contains search misses an apparent match: inspect the cell for leading or trailing spaces, punctuation, line breaks, or nonprinting characters. Also verify that the condition is applied to the intended column rather than another field with similar content.
- Only part of the list gets filtered: look for blank rows or columns breaking up the range, or select the full data block before turning on Filter. Converting a well-structured range to a table can make the data boundaries clearer.
- The menu shows a different filter type: Excel uses the contents it recognizes in a column to offer relevant controls. Check whether numbers, dates, or mixed data have been stored in the same column as text.
To remove one condition while keeping other column filters, open that column’s dropdown and choose its clear-filter command. To clear filters across the current data range, use Data > Clear. Clearing a filter reveals rows again; it does not erase the data. Turning Filter off removes the dropdown arrows, so use that only when you no longer need the filter controls.
When Advanced Filter or Power Query is a better fit
For criteria that go beyond AutoFilter’s two-condition Custom Filter, Excel’s Advanced Filter can use a criteria range on the worksheet. The criteria range lets you lay out conditions explicitly, including combinations across fields, and Advanced Filter can either filter the existing list or copy matching records to another location. It requires more setup than choosing Contains from a dropdown, so it is most useful when the logic is complex or the result needs to be copied elsewhere.
Power Query is another option when filtering is one step in a repeatable data-preparation process, especially when importing or combining data from sources such as files or databases. It records transformation steps that can be refreshed, unlike a simple AutoFilter view, which is primarily an interactive way to inspect rows in the current worksheet. For a quick one-time search through a list, the normal Text Filters menu is usually simpler.
Frequently Asked Questions
How do I filter cells that contain a word in Excel?
Open the column’s dropdown, choose Text Filters > Contains, enter the word, and select OK. Excel keeps rows where that column’s text includes the entered characters.
Can Excel filter text that starts or ends with specific characters?
Yes. Choose Text Filters > Begins With or Ends With, enter the characters, and apply the condition. The corresponding Does Not options exclude matches instead.
Are Excel text filters case-sensitive?
No. Standard AutoFilter text comparisons do not distinguish uppercase from lowercase. Spaces and other characters can still affect whether the text matches.
How do I show two words in the same text column?
Use Text Filters > Custom Filter, set a Contains condition for the first word and another for the second, then select Or if either word should qualify. Select And only if both must appear in the cell.
Does filtering delete the rows that do not match?
No. Filtering hides nonmatching rows temporarily. Use the column’s clear-filter command or Data > Clear to show them again.
Related
- Excel Shortcut to Go to a Specific Column in Seconds
- Excel Shortcut to Insert a Cut Row
- Excel Shortcut to Select to the End of a Column
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel COUNTIF Contains Text from Another Cell?Yes, use COUNTIF(range, "*"&cell&"*") to count cells that contain the text from another cell. For example, =COUNTIF(A2:A10, "*"&B1&"*")…
- Excel Scenario Manager Examples for What-If AnalysisExcel Scenario Manager examples include comparing low, expected, and high sales forecasts, testing different staffing plans, or checking…
- MS Access Split Function: Syntax and ExamplesYes. Microsoft Access’s VBA Split function divides a string into a zero-based array of smaller strings wherever it…
- Excel LET Function: Benefits, Examples, and LimitsExcel’s LET function lets you give names to values and calculations inside a formula, making complex formulas easier…
- How to Highlight in Excel Using a FormulaTo highlight cells or entire rows in Excel based on a condition, select the range, then choose Home…
- Excel Formula for Number of Hours WorkedTo calculate hours worked when a shift starts in A2 and ends in B2 on the same day,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.