Excel Find Not Working? Fix Search and Find Settings

If Excel Find is not working, press Ctrl+F, open Options, and check the search scope and Look in setting; then turn off Match case and Match entire cell contents unless you need them. A saved format filter or searching formulas when you expect displayed values can also make a real match seem missing.

Start with the quick checks

In Excel for Microsoft 365 on Windows, press Ctrl+F to open Find, or choose Home > Find & Select > Find. Select Options if the dialog does not show its full set of controls. Confirm that Find what contains the exact text or number you want, and remove accidental spaces before or after it.

Then check three settings that commonly narrow the search without being obvious:

Within: Choose Sheet to search the active worksheet or Workbook to search across worksheets.
Look in: Choose Values for displayed results or Formulas to search formula text.
Match options: Clear Match case and Match entire cell contents for a normal partial, case-insensitive search.

If Find still reports no result, click Find All rather than relying only on the first match. Find All lists every match Excel found and can help reveal that the result is on another sheet or in a place you were not expecting. On a Mac, Command+F opens Find; use the same scope and matching checks in the Find dialog. In Excel for the web, use Excel’s Home > Find & Select > Find command rather than the browser’s Ctrl+F, which searches the page interface instead of reliably searching workbook cells.

Check whether Excel is searching the right scope

Find can search only the current sheet or the entire workbook. If you know a word is present but do not know which tab contains it, set Within to Workbook. If you want to limit the search to one sheet, set it to Sheet and confirm that the correct worksheet is active. A common mistake is to leave the dialog set to Sheet after previously searching a single tab, then assume Excel searched every tab.

Also consider whether you selected a range before opening Find. A selection can limit the search to that area. Click a single cell outside the intended range, or select the cells you genuinely want to search, and try again. This is particularly useful in large workbooks: searching a deliberately selected column can avoid results from unrelated notes or calculations elsewhere.

The Search setting, usually By Rows or By Columns, controls the order in which Excel looks through cells; it does not normally determine whether a match exists. Changing it may make the next result appear in a different order, but it is not a substitute for setting the correct sheet or workbook scope. Find searches cell content, not just the rows currently visible on screen. A result in a filtered or hidden row may therefore be found even though you cannot see it in the grid. Check the row and sheet shown for a match before concluding that Find returned the wrong data.

Choose Values or Formulas deliberately

The Look in setting is one of the most important causes of a failed search. A cell containing a formula has both the formula text and a calculated result. For example, a cell might contain a formula that adds two cells and display the result 125. Searching for 125 is a search for the displayed result, so Look in: Values is usually the right choice. Searching for part of the formula itself calls for Look in: Formulas.

Suppose a cell displays North Region but its formula builds that text by joining other cells. A search for North can find the displayed text when Excel looks in values, while looking in formulas searches the formula characters instead. The reverse can happen when you are trying to locate a reference, function name, or text constant inside formulas: searching values will not necessarily find the formula syntax you need.

Excel’s dialog may also offer Notes as a Look in choice; older versions or existing workbooks may use the term Comments for some annotation features. If you are searching a cell note, select the relevant option rather than expecting a search of values or formulas to include it. When unsure, try Values and Formulas separately. Avoid assuming that Find searches every part of a cell, including its comments, formula, displayed result, and formatting, in one pass.

Calculation is a separate issue. If a formula’s result is stale because the workbook uses manual calculation, a search for the expected new result may not match what Excel currently has calculated. Check Formulas > Calculation Options and choose Automatic if that is appropriate for the workbook, or recalculate with F9. Changing calculation settings can affect a large workbook, so consider why manual calculation was selected before changing it.

Review match options and saved formatting criteria

Match case makes Excel distinguish uppercase and lowercase letters. Match entire cell contents requires the search term to be the whole cell value, not merely part of it. For example, with Match entire cell contents selected, searching for East will not match a cell containing East Office. Clear that option when you want a partial match; leave it selected when you need an exact cell match.

Find can also retain a formatting condition from an earlier search. If a format criterion is active, Excel may search only cells with that formatting, so matching text in cells with other styles is ignored. In the Find dialog, inspect the Format control. If a format is specified, use its clear-format option, where available, or reset the criterion and search again. This is different from changing the worksheet’s formatting: you are clearing the search filter, not removing cell styles from the workbook.

Retained settings can make Find seem inconsistent between searches. If a search works on one workbook but not another, reopen Options and review the settings instead of assuming Excel is malfunctioning. A reliable diagnostic is to clear Match case, Match entire cell contents, and any format condition, then search a distinctive word using the correct Look in and Within choices. Restore stricter settings only when the task requires them.

Understand wildcards and special characters

Excel Find supports wildcard characters. An asterisk (*) can stand for any number of characters, and a question mark (?) can stand for one character. Searching for pro* may return cells containing words such as project or product. Searching for c?t can match cat or cut, because the question mark represents one character. Wildcards are useful for intentional pattern searches, but they can produce unexpected results if you meant to search for a literal symbol.

To search for a literal asterisk, question mark, or tilde, precede it with a tilde (~). For example, search for ~* to find an actual asterisk in cell content. A tilde itself is represented by ~~. If your search term contains these characters and produces overly broad results or no expected match, check whether Excel is interpreting them as wildcards.

For ordinary phrases, type the phrase directly without adding quotation marks. Find is not a full-text search engine: it does not interpret quoted phrases, operators, or complex expressions in the same way as a web search. If you need several separate terms, search for them individually or use filters and other worksheet tools suited to the task.

Find and Replace has its own common pitfalls

Ctrl+H opens Replace on Windows; Command+H is the corresponding shortcut in Excel for Mac. Replace uses many of the same scope, Look in, match, and format settings as Find, so an unexpected replacement can be caused by the same hidden criteria. Check whether Within is set to Sheet or Workbook and review the options before using Replace All.

Use Find Next or Find All first to confirm which cells match. Then use Replace for a single change when you want to inspect it, or Replace All only when every match should change. For instance, replacing the short text cat could alter a longer word if the search is not restricted to entire cell contents. A replacement can also affect formulas if Look in is set to Formulas. Save a copy before a broad replacement, especially in a workbook with formulas, labels, or imported data that may contain the same text in different contexts.

When Find still cannot locate a visible item

Check what is actually stored in the cell. A value that looks like text may include a nonbreaking space, a line break, or a character copied from a website that resembles an ordinary space. You can inspect the cell in the formula bar, edit the text carefully, or copy a small sample into a plain-text editor to compare characters. Leading and trailing spaces are easy to overlook, and a visually similar character may not be the same character Excel is searching for.

Dates and numbers can be confusing because their display depends on formatting. A date may be stored as a serial number and shown in a date format; a number may display commas, decimal places, or a currency symbol that is not part of the underlying value. If Find does not match the way a cell looks, try a distinctive portion of the displayed text with Look in set to Values, and check the cell’s number format. Do not assume that every visible symbol is stored as literal text.

Finally, check that you are in the expected workbook and worksheet, and that the item is truly cell content rather than a chart label, shape, or image. Standard Find is intended for worksheet cell content and does not search every object or every visual element on a sheet. If the value is in a text box or chart, select that object and inspect it directly. If the dialog behaves abnormally in a single workbook, save a copy and reopen it; avoid editing the original file destructively while troubleshooting.

Frequently Asked Questions

Why does Excel Find only search the current sheet?
Check the Find dialog’s Within setting. Choose Workbook to search across worksheet tabs, or Sheet to search only the active tab. Find may also be limited by a selected range, so click outside an unintended selection and try again.

Why can’t Excel Find a word that is visibly in a cell?
Look in may be set to Formulas instead of Values, Match entire cell contents may be on, or a saved format condition may be filtering results. Also check for leading spaces, unusual characters, and a search term that differs from the cell’s actual content.

How do I make Excel Find part of a cell?
Clear Match entire cell contents in Find Options. Then searching for a word such as East can match a longer cell entry such as East Office. Clear Match case too if capitalization should not matter.

Can Excel Find search inside formulas?
Yes. Set Look in to Formulas to search formula text, such as a function name or a cell reference. Set it to Values when you want to search the calculated results displayed by formulas.

Why does Ctrl+F search the webpage instead of my workbook?
That shortcut may have been captured by your browser. Click inside the workbook and use Excel’s Find command on the Home tab, or use the search control provided by Excel for the web. In desktop Excel for Windows, Ctrl+F opens Excel Find; on Mac, use Command+F.

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.