Excel Filter All Rows Containing Text in a Column

Formulas & functions · Updated November 19, 2026

To filter Excel rows that contain a word or phrase, open the filter arrow in the relevant column and choose Text Filters > Contains, then enter the text and select OK. Excel hides rows that do not match; it does not delete them. If you mean rows where the text can appear in any column, use a helper column or a formula instead.

How Excel’s text filter works

Excel’s built-in filter evaluates values in one column at a time. The Contains condition looks for the entered characters anywhere in each cell’s text, so searching for north can match “North office,” “north-east,” and “Headquarters north.” It is different from Equals, which requires the cell value to match the criterion, and from Begins With or Ends With, which check a particular position.

Filters apply to records in a list: when a row does not meet the condition in the filtered column, Excel hides the entire row. Other columns in the row remain part of the record, but they are not independently searched by that one filter. You can apply additional filters to other columns to narrow the visible results further.

Text filters are generally not case-sensitive. A search for urgent will normally include “Urgent” and “URGENT” as well as lowercase matches. That makes the built-in option convenient for ordinary searches, but it is not suitable when capitalization itself must distinguish a match.

Apply a Contains filter step by step

  1. Check that the data has one clear header row, with a heading for each column and no merged cells in the list.
  2. Select a cell in the data range. If the list has blank rows or columns within it, select the complete range, including its headers, so Excel does not guess the range incorrectly.
  3. On the ribbon, choose Data > Filter. On Windows, Ctrl+Shift+L toggles filters on or off. On a Mac, use Data > Filter if that shortcut is unavailable or differs in your Excel setup.
  4. Select the filter arrow in the heading of the column you want to search. Choose Text Filters > Contains.
  5. Enter the word or phrase in the dialog box and choose OK. Excel displays matching records and hides nonmatching rows.

For example, suppose column C is headed Notes and contains comments about customer requests. Choosing Contains and entering callback can show notes such as “Please call back Thursday” and “Callback requested,” while hiding rows without that text. The search does not require the word to be at the beginning of the cell.

To remove the condition, open the same column’s filter arrow and choose Clear Filter From [column name], or use Data > Clear to clear filters across the range. Choosing Data > Filter again turns the filter controls off; it is not the same as clearing a condition, so clear filters first if you want all records visible.

Make sure the filter covers the whole list

For a frequently updated dataset, convert the range to an Excel table with Insert > Table, or use Ctrl+T on Windows after selecting the data. Confirm that My table has headers is selected when appropriate. Tables add filter arrows to their header row and typically extend to include data entered immediately below or beside the table. They also make it easier to refer to named columns in formulas.

A regular filtered range works too, but the range matters. If a blank row splits the data, Excel may treat the section below it as a separate region when you turn on filters from a single selected cell. Likewise, selecting only one column can cause filtering to affect that column rather than the complete record. When in doubt, select the full rectangular range, including every column that belongs to each record, before choosing Data > Filter.

Headers help both Excel and the person using the workbook understand which field is being filtered. Avoid multiple header rows, merged headings, and completely blank heading cells. If your source data has a title above the headers, do not include that title as though it were a data header.

Search across every column in a row

A column’s Contains filter cannot search all the other columns at once. If a row should match whenever a term appears in any of several fields, add a temporary helper column. For example, if the row’s searchable text is in A2:D2, put this formula in E2 and fill it down:

With the row’s searchable values in A2:D2, enter =COUNTIF(A2:D2,"*urgent*")>0 in E2. It returns TRUE if at least one cell contains urgent, and FALSE otherwise. Filter the helper column to show TRUE. The asterisks mean that any characters may occur before or after the search word.

This approach is useful when the fields are a mix of names, descriptions, and comments, and you want one result list. You can label the helper column “Has urgent” and remove it later if it is only for a one-time search. Keep the formula range limited to the columns that should count: including a record number or an unrelated status field could create matches you did not intend.

COUNTIF criteria treat the asterisk as a wildcard for any number of characters and the question mark as a wildcard for one character. If the search text itself includes wildcard symbols that should be matched literally, escape them in the criteria with a tilde; for example, ~* represents a literal asterisk. Review the results when searching for symbols or unusual codes.

Return matching records with a formula

If you want a separate, automatically updating result list instead of hiding rows in place, use FILTER in Excel for Microsoft 365 or Excel 2021 and later. With records in A2:D100 and the text to check in B2:B100, enter:

With the complete records in A2:D100 and searchable text in B2:B100, use =FILTER(A2:D100,ISNUMBER(SEARCH("urgent",B2:B100)),"No matches"). This returns every row whose B-column value contains urgent, or displays “No matches” if none qualify.

SEARCH finds the text without regard to capitalization, and ISNUMBER converts a successful search position into a TRUE condition for FILTER. The source and condition ranges must cover the same number of rows. Put the formula in an empty area with room for the results to spill; existing content in the output area can cause a #SPILL! error. The formula’s result is a dynamic view, not a replacement for the source records.

SEARCH can treat asterisk and question mark characters as wildcards. If the search term includes those symbols and you mean them literally, account for that behavior rather than assuming every character is an ordinary letter. For a case-sensitive formula match, replace SEARCH with FIND; with the same ranges, the formula is =FILTER(A2:D100,ISNUMBER(FIND("Urgent",B2:B100)),"No matches"). FIND distinguishes “Urgent” from “urgent.”

Choose the right method for the job

  • Use Text Filters > Contains for a quick search in one field when you want to inspect the original list and do not need a separate output range.
  • Use filters on multiple columns when each condition belongs to a particular field—for example, a city contains “York” and a status equals “Open.” Conditions on separate columns narrow the visible records together.
  • Use a helper column when a match in any of several fields should qualify the row, or when you need a clear TRUE/FALSE result to filter or count.
  • Use FILTER when you want a live extracted list for a report or another calculation, and your Excel version supports the function.

Filtering and deleting are different operations. A filter only changes which rows are currently visible, so clearing it restores the hidden records. Before deleting or copying only visible results, confirm that the filter is active and that the selection contains the intended rows; otherwise, you may act on more of the dataset than expected.

Common problems and fixes

No expected match appears: Check for spelling differences, extra spaces, or a different column than the one selected. Also check whether another column has an active filter; several filters can remain in effect at once, making the combined result smaller than expected. Use Data > Clear to restore all records and try the search again.

Only part of the list changes: The filter may not include the full dataset. Clear it, select the complete range, and turn on Data > Filter again, or convert the data to a table. Look for blank rows or columns that may have separated the range.

Numbers or dates do not behave like text: Excel can offer different filter choices depending on the type of values in a column. If you are looking for a number embedded in descriptive text, use a text filter on the column that actually stores that text. A numeric value such as 120 is not necessarily treated the same as the characters “120” inside a text description.

The list looks incomplete after editing: A filter can remain active while data changes. Reopen the filter arrow and check the selected values or condition, or clear the filters to see the full list. If a new record was added outside a regular filtered range, expand the range or place it within the table so it is included.

The formula reports an error: For FILTER, check that the output cells are empty, that the data and condition ranges have matching heights, and that your Excel version includes the function. In a localized Excel installation, function names or formula separators may differ from the English examples here.

Frequently Asked Questions

Can Excel filter cells that contain part of a word?
Yes. Choose Text Filters > Contains and enter the characters to find. Excel can match that sequence within a longer cell value, not only a complete word.

Does Contains filter match uppercase and lowercase differently?
Normally, no. Excel’s built-in text filter is not case-sensitive. For a case-sensitive formula-based result, use FIND inside FILTER rather than SEARCH.

How do I filter rows containing either of two words?
For one column, open Text Filters > Custom Filter and set two Contains conditions joined with OR, if that option is available in the dialog. To search several columns, use a helper formula that checks the relevant fields and filter its TRUE results.

Can I filter a whole row for a word without adding a helper column?
The standard column filter checks the selected column, not every cell in the row. A helper column or a FILTER formula is the straightforward way to test multiple fields together.

Does filtering remove the rows that do not match?
No. It hides them from the current view. Clear the filter to show them again; deleting records is a separate action.

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.