Search Excel for Text: Find Cells and Match Content

Formulas & functions · Updated November 18, 2026

To search Excel for text, press Ctrl+F on Windows, type the word or phrase, then press Enter or choose Find All. Use the search options to look in the current sheet or the whole workbook, and to match case or an entire cell. On a Mac, use Command+F.

What Excel’s text search finds

Excel’s Find command looks for characters in worksheet cells. By default, it can find a word inside a longer entry: searching for west can match a cell containing “Northwest Depot.” It can also find a phrase, number, or punctuation, so long as the search target appears in the content Excel is checking.

Finding text does not change the workbook. Excel selects a matching cell, and you can move through further matches or review a list of them. This is different from replacing text, which edits cell contents, and from a formula that checks text as part of a calculation.

Search is useful for locating a name in a contact list, a product code in an inventory, a note in a project tracker, or a label on a large worksheet. It can also search a workbook with multiple sheets, provided you change the search scope from the current sheet to the workbook.

Search a worksheet step by step

  1. Open the worksheet you want to search. If you want to search only a particular block of cells, select that range first.
  2. Press Ctrl+F on Windows or Command+F on Mac. You can also use Home > Find & Select > Find on the Windows ribbon.
  3. Enter the text in the Find box. For example, enter invoice to locate cells containing that word.
  4. Choose Find Next to select a match and move through results one at a time, or choose Find All to show the matches together in the Find and Replace dialog.
  5. Close the search pane or dialog when you are done. The selected cell remains active, so you can inspect its row, column, or surrounding data.

In Microsoft 365 for Windows, Ctrl+F commonly opens the Navigation pane. The Find box there is enough for a straightforward search; use its search options or the ribbon’s Find command when you need controls such as workbook scope or whole-cell matching. On Mac, Command+F opens the Find interface, though the layout can differ by Excel version. The Find command is also available from the Home tab.

Choose what and where to search

The Find and Replace dialog provides options that affect which matches Excel returns. In the dialog, choose Options if the settings are not visible. Check these before deciding that a value is missing:

  • Within: Choose Sheet to search the active worksheet or Workbook to include other sheets in the file. A workbook-wide search can reveal a match on a tab you have not opened.
  • Search: Choose to move through cells by rows or columns. This changes the order in which matches are visited, not which cells qualify.
  • Look in: Choose whether Excel checks formulas or the values displayed in cells, where those choices are available. For example, a cell may display Completed while its formula contains a reference and calculation rather than that word.
  • Match case: Turn this on when capitalization matters, such as distinguishing an ID that uses uppercase letters from one that uses lowercase letters.
  • Match entire cell contents: Turn this on to find cells whose whole content is the search text, instead of cells that merely contain it as part of a longer entry.

Excel remembers Find settings in many situations. If a search behaves unexpectedly, reopen Options and check the scope, case, whole-cell, and Look in settings rather than assuming the workbook has no match. If you selected a range before searching, Excel may limit the search to that selection; clear the selection or select the full sheet to broaden the search.

Use wildcards for flexible matches

When exact typing is not practical, Excel’s Find command accepts wildcard characters. An asterisk represents any number of characters, including none; a question mark represents exactly one character. These are useful for searching a group of related labels or codes.

  • Search for north* to find entries beginning with “north,” such as “north” or “northern depot.”
  • Search for t?p to match three-character text such as “top” or “tip,” where the middle character can vary.
  • Search for ~* to look for a literal asterisk, or ~? for a literal question mark. A tilde tells Excel to treat the next wildcard character as ordinary text.

Wildcards are not the same as ordinary punctuation in a search. If your data contains literal question marks or asterisks, prefix them with a tilde so Excel does not interpret them as patterns. A wildcard search can also return more matches than expected, so review the results before using Replace All.

Find text with a formula instead

Use a worksheet formula when you need a reusable test, such as a helper column that flags every row containing a search term. The SEARCH function returns the position where one text string begins inside another; it is not case-sensitive. FIND does a similar job but is case-sensitive. Both functions return an error when there is no match, so wrapping SEARCH in ISNUMBER produces a convenient TRUE-or-FALSE result.

With sample text in A2, the formula =SEARCH("cat",A2) returns 7 when A2 contains “Black cat,” because “cat” begins at the seventh character. This formula tests one cell and returns a position, rather than opening Excel’s Find interface or searching every worksheet.

With text entries in A2:A20 and a search term in D1, enter =ISNUMBER(SEARCH($D$1,A2)) in B2 and copy it down through B20. If D1 contains west and A2 contains “Northwest Depot,” B2 returns TRUE; a row without the term returns FALSE. The dollar signs keep the query cell fixed while the row reference changes as the formula is copied. If D1 is blank, SEARCH treats the empty text as a match, so use a nonblank query or add a separate blank check if that behavior is not wanted.

This formula approach is useful when results need to remain visible alongside the data or feed another calculation. For a one-time lookup, Ctrl+F is usually simpler. For a test across many rows, a helper formula is easier to audit and update than manually visiting each match.

Common reasons a search misses text

A search with no results does not always mean the text is absent. The most common causes are a restrictive setting, a mismatch between displayed values and formulas, or characters in the data that are not obvious on screen.

  • Wrong search scope: The search may be limited to one sheet when the match is on another. Change Within to Workbook.
  • Whole-cell matching is enabled: Searching for west will not match “Northwest Depot” if Excel is required to match the entire cell.
  • Case matching is enabled: A search for lowercase text may skip differently capitalized text when Match case is selected.
  • Looking in the wrong content: A displayed result can differ from the formula in its cell. Try the other Look in choice in the Find options.
  • Extra spaces or hidden characters: Pasted data can contain leading spaces, nonbreaking spaces, or other characters that are hard to see. Searching a shorter distinctive fragment can help locate the entry.
  • Wildcard characters are being interpreted: If the data contains a literal asterisk or question mark, escape it with a tilde in the Find box.

For a quick check, search for a shorter part of the target and inspect the cell directly. If the value comes from a formula, click the cell and review the formula bar. If it was copied from a website or external system, compare the text carefully; visually similar characters and unusual spaces can prevent a match.

Find, filter, or replace?

Choose the tool according to what you want to do. Find locates text and selects matching cells. Filter hides rows that do not meet criteria, which is more useful when you want to review a working subset of a table. For a text filter, use the column’s filter arrow and choose a text condition such as Contains, where available. Filtering changes what is shown, not the underlying cell contents.

Replace edits matching content. Open it with Ctrl+H on Windows or Command+Shift+H on Mac, or choose Home > Find & Select > Replace on Windows. Review the search scope and matching options carefully. Use Replace to handle a match at a time; use Replace All only when you intend to change every qualifying match. Save a copy first if the change could affect important data, because a broad replacement can alter many cells quickly.

Frequently Asked Questions

How do I search all sheets in an Excel workbook?
Open Find and Replace, show Options if needed, and set Within to Workbook. Then enter the text and choose Find Next or Find All. With the default sheet scope, Excel searches only the active worksheet.

Can Excel search for part of a word?
Yes. By default, Find can match text inside a longer cell entry. Searching for ship can locate “shipping” or “shipyard.” Make sure Match entire cell contents is turned off if you want partial matches.

How do I make an Excel search case-sensitive?
Open the Find options and select Match case. With that setting enabled, capitalization matters. If you use a formula instead, FIND is case-sensitive, while SEARCH is not.

Can I search for text inside formulas?
Yes. In the Find and Replace options, set Look in to Formulas. This checks formula text rather than only the value displayed in the cell. The choices shown can vary slightly among Excel versions.

How do I find a word in Excel without changing anything?
Use Ctrl+F on Windows or Command+F on Mac, type the word, and choose Find Next or Find All. Avoid the Replace command if you only want to locate cells; Find selects matches without editing them.

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.