Excel Find and Replace Not Finding Anything? Fix It

If Excel Find and Replace is not finding anything, first check the search scope and options: press Ctrl+H, set Within to Sheet or Workbook as intended, choose the right Look in setting, and clear Match case, Match entire cell contents, or any saved format filter that does not fit. Also make sure you have not selected only part of the worksheet; Excel may be limiting the search to that selection.

Start with the search scope

In Excel for Microsoft 365 on Windows, open Replace with Ctrl+H or choose Home > Find & Select > Replace. In the dialog, the Within setting controls whether Excel searches the current sheet or the whole workbook. If you expect a match on another tab but Within is set to Sheet, Excel will not find it. Set Within to Workbook to search across worksheets.

A selected range can also restrict what Excel searches. For example, if A1:A20 is selected, a search may be limited to those cells instead of the entire sheet. Click a single cell before searching to avoid an unintended range limit. If you do want to search only a range, select it deliberately and verify that the match should be inside it.

One worksheet: Set Within to Sheet and confirm you are on the right tab.
Several worksheets: Set Within to Workbook. Check the sheet name shown in the results, because a workbook search can find matches on tabs you were not viewing.
A specific block: Select that block, then search and confirm the target is within the selection.

Excel for Mac has the same basic scope distinction. Use Edit > Find > Replace to open the dialog; available shortcut keys can differ by Mac keyboard and Excel configuration. Excel for the web also has find-and-replace controls, though the dialog layout may differ from the Windows desktop app.

Check the options that narrow a match

Find and Replace can be more restrictive than the text in its search box suggests. In the expanded dialog, inspect Match case and Match entire cell contents. If Match case is enabled, searching for north will not match North. If Match entire cell contents is enabled, searching for cat will not match a cell containing catalog or the phrase a cat.

These options can be useful when the data is clean and you intend an exact match, but they often explain an apparently empty search. Turn them off for a broad search, then use Find All to see the matches before replacing anything. Find All displays the matching cells, which is a useful way to confirm that Excel is searching the right worksheet and returning the expected kind of result.

Also inspect any formatting criterion attached to the search. In the Find and Replace dialog, a Format condition can tell Excel to find text only in cells with specified formatting. A search may therefore miss identical text in cells with a different font, fill, or number format. If the dialog indicates that a format is set, use the format control to clear it, then search again. Saved options can carry over from earlier searches, so a fresh-looking text box does not guarantee that every other setting is neutral.

Choose the right Look in setting

The Look in option determines what Excel examines in a cell. For ordinary data, Values is usually the most intuitive choice. If you are trying to locate text that is part of a formula, choose Formulas. For example, a cell might display a result such as North Region while its formula refers to a lookup table and contains no literal text North Region. Searching formulas and searching calculated values are different tasks.

Consider a cell whose formula combines a first name and a last name. Searching for the displayed full name may work when Excel looks at calculated values, but a formula search examines the formula text instead. Conversely, if you need to change a text fragment inside formulas, a values-only search may not expose that formula text as a match. Check the Look in choice before concluding that the workbook does not contain the text.

Numbers can be confusing for a related reason: a cell may display a formatted value rather than the raw value. A date, percentage, or currency amount can have a display that differs from the stored number. If searching for what appears on screen does not work, inspect the cell’s formula bar and number format, and try the relevant Look in mode. Do not assume that the characters shown by a custom number format are stored as text in the cell.

Understand partial text, spaces, and special characters

What looks like a matching word may contain different characters. A cell can have a leading or trailing space, two spaces between words, a line break, or a nonbreaking space copied from a website. These characters are easy to overlook on screen. For instance, searching for East may not find a cell that contains East followed by a nonbreaking space if the search text does not include the same character sequence.

Check a suspect cell in the formula bar, widen the column, or copy its contents into a plain-text editor to inspect it. A simple search for a shorter distinctive fragment can help determine whether the issue is an invisible character or a restrictive option. Be cautious about replacing spaces globally: a workbook may use spaces intentionally in addresses, labels, or text fields.

Excel also supports wildcard search patterns:

Asterisk (*): Matches any number of characters. Searching for pro* may match product and program.
Question mark (?): Matches one character. Searching for c?t can match cat or cot.
Tilde (~): Treats a wildcard character literally. Search for ~* to find an actual asterisk, or ~? to find a question mark.

If a search unexpectedly returns many results, check whether an asterisk or question mark is being interpreted as a wildcard. If you need to find a literal wildcard character, prefix it with a tilde. This is a frequent source of confusion in spreadsheets containing codes or filenames.

Look for data that is not ordinary cell text

Not every visible item is a normal cell value. A word in a chart title, text box, shape, header, or footer may not be found by the worksheet cell search. Likewise, a match may be in a comment or note rather than in the cell’s value or formula. If you can see the text but Find does not return a cell, determine which object contains it and search or edit that object directly.

Hidden rows, filtered rows, and hidden worksheets can make results seem missing or surprising. A worksheet search is not necessarily limited to the rows currently visible through a filter. A workbook-wide search can also return a match on a hidden tab. Use Find All and check the sheet and cell references before taking action. If the target is in a chart or drawing object, select the object and edit its text rather than relying on cell replacement.

Another common misconception is that Find searches only the visible text exactly as it appears. Formatting can change how a value looks without changing the stored content. A date displayed as 2-Nov-2026, for example, is stored as a serial number with a date format. Searching for the displayed date may behave differently from searching for literal text containing those characters.

Use Replace All carefully

Once Find All shows the expected cells, Replace is safer than Replace All when you are uncertain. Replace changes a match one at a time, giving you a chance to inspect each result. Replace All changes every match in the selected search scope in one operation, including matches on other worksheets if Within is set to Workbook. It can also change cells you did not notice in a filtered or hidden area.

Before a broad replacement, consider saving a copy of the workbook. Then verify the search term, replacement text, scope, Look in setting, and match options. A replacement that is too short can damage unrelated words: replacing art with design could alter the word article if the search is not restricted to entire-cell matches. Find All provides a review step, but it does not itself change data.

Replacing text in formulas deserves extra care. If the search is set to formulas, Excel can replace characters within formula expressions, not just labels or displayed results. A change to a function name, sheet reference, text constant, or named range may affect calculations. After replacing formula text, check important outputs and inspect representative formulas. Ctrl+Z normally reverses a recent Replace All operation in desktop Excel, but do not treat Undo as a substitute for a backup, especially if you continue editing afterward.

A practical troubleshooting sequence

When a known word still produces no results, use this sequence rather than changing several settings at once:

Click one cell in the sheet, so an accidental small selection is not limiting the search.
Open Replace with Ctrl+H on Windows, or use Edit > Find > Replace on Mac.
Enter a short, distinctive part of the target text rather than a long phrase that may contain an invisible space.
Set Within to Sheet or Workbook according to where the match is expected.
Choose Values for calculated or ordinary displayed content, or Formulas when looking for text inside formula expressions.
Clear Match case and Match entire cell contents unless you intentionally need those restrictions.
Clear any Format condition, then choose Find All and review the returned sheet names and cell addresses.
If the text remains missing, inspect the source cell, consider wildcard escaping, and check whether the visible text belongs to a shape, chart, note, or other object.

This order helps isolate the cause. If relaxing one setting makes the match appear, restore other settings only when they serve a specific purpose. For example, use Match entire cell contents to replace a complete status label without changing longer labels that merely contain the same word.

Frequently Asked Questions

Why does Excel find a word in one sheet but not another?
Check the active sheet and the Within setting. Sheet searches only the current worksheet, while Workbook searches across sheets. Also confirm that the other sheet is not hidden and that your search is not limited to a selected range.

Why does Find All work but Replace All change too many cells?
Find All may show matches across the full scope, including other tabs or hidden rows. Review the result list and set Within to Sheet if appropriate. Use Replace one result at a time when you need to verify each change.

Can Excel Find search inside formulas?
Yes. Set Look in to Formulas to search formula text. Use Values when you want to search calculated results or ordinary displayed cell content. A formula’s text and its result are not necessarily the same.

Why does Excel miss a word that I can see in the cell?
The cell may contain an extra space or a different invisible character, or the visible text may be produced by formatting. Check Match options, Look in, and any format criteria; then inspect the underlying cell content in the formula bar.

How do I find an actual asterisk or question mark?
Because * and ? act as wildcards in Excel searches, put a tilde before the character: search for ~* to find an asterisk or ~? to find a question mark.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.