Excel Text Filters: How to Find Matching Rows Easily

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select a cell in your data and choose Data > Filter, then open the column’s filter arrow and choose Text Filters. Select a condition such as Contains, Begins With, or Equals, enter the text to match, and select OK; Excel hides rows that do not meet the condition without deleting them.

What Excel text filters do

A text filter narrows a list by checking the text values in a chosen column. For example, a customer list could be filtered to show names containing Lee, product descriptions beginning with Cable, or status entries equal to Pending. The rest of the worksheet remains in place, but rows that fail the filter are temporarily hidden.

Text filters are part of Excel’s ordinary AutoFilter feature, not a separate add-in. They are useful when you need to inspect or work with a subset of a larger list without making a second copy of the data. A filter can be removed later to show all records again. It does not change the underlying cell values, calculate a new list, or permanently remove excluded records.

Excel generally treats text comparisons in AutoFilter as case-insensitive, so a criterion for pending also matches Pending or PENDING. A text filter is different from sorting: sorting rearranges the visible records, while filtering determines which records are currently shown. You can use both on the same data.

Prepare the data before filtering

Excel needs to identify the header row and the range of records. A simple, continuous list is easiest to filter: use one descriptive heading per column, put each record on its own row, and avoid completely blank rows or columns inside the data. Keep different kinds of information in separate columns. For instance, put a city in one column and a postal code in another rather than combining them in one field.

Click within the data before turning on the filter. Excel usually detects the surrounding range, but check that the arrows appear on the intended headers and that all relevant rows are included. If the list is formatted as an Excel table, its header row normally has filter arrows already. To make a table, select the range and choose Insert > Table, then confirm whether the range has headers. Tables expand as records are added and are often convenient for ongoing lists.

  • Use a single header row, with no merged header cells.
  • Keep each column’s values consistent. A column mixing text, numbers, and unusual entries may not offer the filtering choices you expect.
  • Remove accidental leading or trailing spaces when they make entries look alike but behave differently.
  • Check for blank rows that could cause Excel to treat part of the list as a separate range.

These are practical guidelines, not a requirement that every data set be perfectly uniform. Excel can filter imperfect lists, but inconsistent layout makes it easier to omit records or misread the results.

Apply a text filter step by step

  1. Select a cell in the range. On the ribbon, choose Data > Filter. You can also use Home > Sort & Filter > Filter.
  2. Open the dropdown arrow in the header of the column you want to inspect.
  3. Point to Text Filters. Choose the condition that fits the question, such as Contains or Begins With.
  4. Enter the value in the dialog. For example, to find descriptions containing the word adapter, choose Contains and enter adapter.
  5. Select OK. Excel displays the matching rows and hides the others.

For a quick search among the distinct values in a column, open its dropdown and type into the Search box. This helps locate a particular listed value or narrow the checkbox list. It is not the same as defining a condition such as contains a phrase: use Text Filters when you need to specify a comparison rule, rather than simply find an item in the menu.

To remove a filter from one column, open its dropdown and choose Clear Filter From followed by the column name. To remove filters from the range, use Data > Clear. The arrows can remain available after the criteria are cleared. To turn AutoFilter off, choose Data > Filter again.

Choose the right text condition

The condition should match the question you are asking. Equals is suitable when the whole cell value should match a value, such as a status of Open. Contains finds the entered text anywhere in the cell, while Does Not Contain excludes cells with that text. Begins With and Ends With are useful for prefixes and suffixes, such as product codes that start with a particular department abbreviation.

Does Not Equal shows values other than the specified entry. It does not mean the same thing as Does Not Contain: if the criterion is cat, Does Not Equal keeps a value such as cat food because the entire cell is not exactly cat, while Does Not Contain excludes it because the characters cat appear inside the value.

Choose Custom Filter when you need two conditions on the same column. For example, a status column could be set to equal Open OR equal In Progress. The dialog also lets you combine conditions with AND when a value must meet both tests. The precise options shown depend on the condition you select.

  • Use Equals for an exact cell value.
  • Use Contains for a word or phrase that may appear within longer text.
  • Use Begins With or Ends With for consistent code prefixes or suffixes.
  • Use Custom Filter when one column needs two criteria joined by AND or OR.

Use wildcards for flexible matching

Text filter criteria support wildcard characters. An asterisk (*) represents any number of characters, including none; a question mark (?) represents one character. For example, a criterion such as North* can match North, Northern, or North Office. A criterion such as B?7 can match B17 or BA7, but not B107, because the question mark stands for only one character.

A tilde (~) lets you search for a wildcard character as a literal character instead. For example, use ~* when you want to match an actual asterisk in the cell rather than treat it as a placeholder. This matters for product names, filenames, or notes that contain * or ?. If wildcard behavior produces unexpected matches, inspect the criterion for those characters.

Wildcards are most useful when a list follows a pattern but does not use one identical value everywhere. They can also make a filter broader than intended: North* includes every value beginning with North, not just the single word North. For a literal exact value, choose Equals and enter that value rather than adding a wildcard.

Combine filters across columns

You can filter more than one column at a time. For instance, filter Region to show West and Status to show Pending. Excel applies the active column filters together, so the visible rows must satisfy the Region condition and the Status condition. This is an AND relationship across columns.

Within one column, Custom Filter can combine two conditions with OR, such as a description containing charger or containing cable. Across different columns, the standard filter arrows do not provide a single OR rule such as Region is West OR Status is Pending; applying both column filters would require both conditions. If your question requires more complex logic, consider a helper column that marks qualifying records, or use Advanced Filter for criteria arranged in a criteria range.

Remember that each column’s dropdown shows choices based on the rows currently visible under other filters. A value may seem to disappear from the list because another column’s filter has already hidden every row containing it. Clear the other filters if you need to examine the full set of available values.

Common problems and how to fix them

If the expected rows do not appear, first confirm that you filtered the correct column and selected the intended condition. Contains, Equals, and Begins With answer different questions. Also check for spaces or punctuation in the source values. For example, a cell containing a trailing space after Pending can look identical to Pending on screen but may not behave like an exact match.

If some records are missing from the filter range, inspect blank rows and the position of the active cell when you enabled AutoFilter. Turn filtering off and on again after selecting the complete data range, or convert the range to a table. When adding records below an ordinary filtered range, confirm that the new rows are included; a table is more likely to expand as new rows are entered directly below it.

If a column contains a mix of text and other data types, the dropdown may show groups or choices that differ from a plain text list. Check the actual cell contents and data type, not only the formatting. Changing a number’s display format does not necessarily turn its stored value into text. Similarly, filtering a column containing dates may present date-oriented choices rather than text conditions.

Filtering hides rows, which can be mistaken for deletion. Use Data > Clear or clear the individual column filter to reveal records again. If you copy filtered data, take care to distinguish visible rows from hidden ones; when the task specifically requires visible cells only, use Home > Find & Select > Go To Special and choose Visible cells only before copying.

Text filters compared with other Excel tools

AutoFilter is a good choice for interactive inspection: it is quick to set up, preserves the original list, and lets a reader change criteria from the header. Find, opened with Ctrl+F on Windows, is better for locating a text occurrence without hiding nonmatching rows. Find does not create a reusable filtered view of the records.

Advanced Filter is useful when the criteria are more involved or when you want to copy matching records to another location. It uses a criteria range with headings that correspond to the data columns, so it takes more setup than the dropdown menu. A formula-based approach can also produce a separate, dynamically updated result list, but that is a different workflow from hiding rows in the source. The FILTER function is available in Microsoft 365 and Excel 2021 or later, and returns matching values in another range rather than applying AutoFilter to the original rows.

For a straightforward question such as which descriptions contain the word repair, the dropdown’s Text Filters is usually the simplest option. For a saved output, a complex set of rules, or a result that must appear elsewhere, choose a tool designed for that purpose instead.

Frequently Asked Questions

How do I filter cells that contain specific text in Excel?
Open the column dropdown, choose Text Filters > Contains, enter the text, and select OK. Excel keeps rows whose cells in that column contain the entered text.

Can Excel text filters distinguish uppercase and lowercase?
AutoFilter text comparisons are generally not case-sensitive. A filter for pending will ordinarily match Pending and PENDING as well. If capitalization is meaningful in your data, use a separate case-sensitive formula or another purpose-built method rather than relying on the standard text filter.

Does filtering delete rows that do not match?
No. A filter hides rows temporarily; it does not delete or rewrite them. Clear the filter to show the full list again.

How do I filter for two words in one column?
Use Text Filters > Custom Filter and enter two conditions, then choose AND if both must apply or OR if either may apply. For two alternatives such as either word appearing in a description, choose Contains for both conditions and join them with OR.

Why is Text Filters missing from the dropdown?
Check that the selected column contains text values and that you opened the dropdown for the intended range. Columns with dates, numbers, mixed data, or a range that was not identified correctly may show different choices. Confirm the column contents and, if needed, select the full data range and turn on Data > Filter again.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.