How to Find Something in Excel: Cells, Sheets, Workbooks

To find text, a number, or a formula in Excel for Microsoft 365 on Windows, press Ctrl+F, enter what you are looking for, and choose Find Next or Find All. Use the search options to look in a particular sheet or across the current workbook, and to match whole-cell contents or letter case. You need an open workbook and a search term; the steps below explain how to narrow the search and what to check if Excel does not find the result.

What You’ll Need

An Excel workbook open in the desktop app, or Excel for the web.
A word, number, or part of a formula you expect to find. If possible, note which sheet may contain it.
For a search across several sheets, the workbook must contain those sheets. Excel’s Workbook search scope does not search other workbooks that happen to be open.

Step-by-Step

Open the Find dialog. In Excel for Microsoft 365 on Windows, press Ctrl+F. You can also select Home > Find & Select > Find. On a Mac, press Command+F or use Home > Find & Select > Find. In Excel for the web, choose Home > Find & Select > Find; keyboard behavior can vary with the browser.
Enter a clear search term. Type the word, number, or part of a formula in the Find what box. Excel searches as you type in some versions, but use Find Next to move to a result you can inspect. Start with a distinctive short piece of the content. For example, searching for 4821 may be more useful than searching for a common word such as total. You do not need to type an equals sign to find a formula; search for a distinctive function or cell reference that appears in it.
Choose where Excel should look. Select Options in the Find dialog if the additional settings are not visible. Set Within to Sheet to search the active worksheet, or to Workbook to search all worksheets in the current workbook. A sheet search is usually quicker when you know where the information belongs. Workbook scope is useful when you are unsure which tab contains it.
Decide whether to match the entire cell or its case. Select Match entire cell contents when the cell must contain only the search term. For example, searching for West with this option selected will not match Northwest. Select Match case when uppercase and lowercase letters must be treated differently. Leave both options cleared for a broader search; Excel’s usual text search is not case-sensitive and can find a term within longer cell contents.
Set what Excel searches inside cells. In Look in, choose Values to search the displayed or calculated cell results, or Formulas to search the formula text. If a cell displays 250 but contains a formula that calculates 250, a search for 250 is most directly aimed at the displayed result when Look in is set to Values. A search for SUM can locate formulas containing that function when Look in is set to Formulas. The available Look in choices can include Notes and Comments as well; choose one of those when you are trying to find text in cell annotations rather than in the cells themselves.
Run the search. Choose Find Next to move to the next matching cell. Keep selecting it to move through further matches. Choose Find All to display a list of matches instead. In the results list, select a match to jump to that cell. Find All is especially helpful when you need to see whether a term appears once or in many places, or when results are spread across several worksheets.
Check the selected cell and its location. Read the cell contents in the worksheet or formula bar, and check the sheet tab and cell reference. A match in a formula is not necessarily a match in the displayed result, and a matching number may be part of a longer value. If the result is not what you wanted, adjust the search term or options rather than assuming Excel has found the exact item.
Search a selected range when appropriate. To restrict the search, first select the cells you want to inspect, then open Find and search. For example, select a table’s Notes column before searching for a phrase if you do not want matches elsewhere on the sheet. When a range is selected, Excel can limit the search to that selection. To return to a whole-sheet search, click a single cell outside the selected range, then run the search again.
Close the dialog when you are done. Press Esc or close the dialog. Finding a cell does not change its contents. If you meant to edit the result, click in the cell or formula bar after confirming that it is the right match.

Find and Replace is a separate tool for changing matches. To open it on Windows, press Ctrl+H or select Home > Find & Select > Replace. On a Mac, use Command+Shift+H or the same ribbon path. Search first and inspect matches before replacing anything, especially if the workbook contains formulas or repeated labels.

Common Mistakes

Searching the wrong scope: A search set to Sheet will not find a match on another tab. Check Within in Options, and use Workbook if you need all sheets in the current file. It will not search every open workbook.
Looking in the wrong cell content: A formula cell has both a formula and a calculated result. If you search for the displayed number while Look in is set to Formulas, Excel may not find it. Switch to Values. If you need to find formula text, switch to Formulas.
Using Match entire cell contents by accident: This option excludes cells that contain extra words, spaces, or other characters. Clear it if you only know part of a cell’s content.
Expecting a case-sensitive search by default: Excel normally treats capitalization as a match. Select Match case only when case matters; otherwise, a search for april can find April.
Confusing Find with Replace: Find only navigates to matches. Replace edits them, and Replace All can change many cells at once. Do not use Replace All until you have confirmed the exact term, search scope, and result you want.
Assuming a blank-looking cell is truly empty: A cell may contain a space, a formula that returns an empty string, or characters copied from another source. A normal search for a visible word will not identify every kind of invisible content.

Tips

Search for a distinctive fragment. If you are looking for a long label, use a unique word or number from it. This can reveal a match even when the full wording differs slightly.
Use wildcards for uncertain text. In Find what, an asterisk (*) represents any number of characters, and a question mark (?) represents one character. For instance, north* can match text beginning with north. To search for an actual asterisk, question mark, or tilde, put a tilde before it: ~*, ~?, or ~~.
Use Find All to review results together. Instead of cycling through each match, Find All shows a list you can use to visit results. It is a practical way to check for repeated names, labels, or values before editing anything.
Check for saved search settings. Excel can retain Find options from an earlier search. If results seem unexpectedly limited, open Options and review Within, Look in, Match case, and Match entire cell contents. Clear settings you do not need.
Search a table column instead of the whole workbook. Selecting the relevant column first can reduce unrelated results in large workbooks. Make sure the selection includes all the rows you intend to check.
Use the formula bar to verify a result. The grid shows the calculated value for many formulas. Selecting a cell and checking the formula bar helps distinguish a literal entry from a formula that produces the same display.
Be cautious with formatted searches. If you previously set a format condition in Find, Excel may search for cells with that formatting as well as the text. Use the Format control in the Find dialog to clear a format condition if the search is missing otherwise obvious matches.

Troubleshooting

Excel says no matches were found. First clear Match entire cell contents and Match case, then confirm that Within is set to the right scope. If the target is a formula result, choose Values under Look in; if you are searching formula text, choose Formulas. Try a shorter, distinctive fragment and check spelling, punctuation, and spaces.

The result is on a different sheet than expected. Check the sheet name shown in the workbook and the Within setting. Sheet searches stay on the active worksheet; switch to Workbook to look across the current workbook. If you selected a range before searching, clear that selection by clicking one cell and try again.

A visible number does not match. The displayed value may be calculated by a formula, while the cell stores a different formula string. Switch between Values and Formulas as appropriate. Also consider that a number formatted as a date, percentage, or rounded value may display differently from its underlying value. Search for a distinctive part of the displayed content, then inspect the selected cell.

Find All returns too many results. Add a more specific term, select the relevant range first, or turn on Match entire cell contents if you need an exact cell match. Check that Workbook scope is necessary; a search across several sheets can include unrelated labels and notes.

Excel finds unexpected matches or misses a copied phrase. Look for extra spaces, punctuation, or nonprinting characters. Search a shorter portion of the phrase, and inspect the cell in the formula bar. If text was copied from a web page or another system, a regular space may have been replaced by a different spacing character that looks similar. You may need to edit or clean the cell contents before a normal search can match it.

The dialog is searching by formatting. Open Find, select Options, and inspect the Format setting. If a format was specified, use the Format control to clear the search format, then try again. Text and formatting criteria can combine, making it seem as though Excel is ignoring matching text.

Frequently Asked Questions

How do I find a word in an Excel sheet?
Press Ctrl+F on Windows, enter the word, and choose Find Next or Find All. On a Mac, use Command+F. Check that Within is set to Sheet if you only want to search the active tab.

How do I search every sheet in a workbook?
Open Find, select Options, and set Within to Workbook. This searches worksheets in the current workbook, not other workbooks or files on your computer.

Can I find a value produced by a formula?
Yes. Set Look in to Values to search the calculated result shown in the cell. Set it to Formulas when you need to search the formula itself.

How do I find an exact match?
Select Match entire cell contents in Find Options. Excel will then look for cells whose complete contents match the search term, rather than cells containing it as part of a longer entry.

Can Excel find text with only part of a word known?
Yes. Search for a distinctive fragment, or use * for any number of characters and ? for one character. Put a tilde before a wildcard character when you want to search for the character itself.

Does Find change the contents of a cell?
No. Find locates a match without editing it. Use Replace only when you intend to change content, and review the scope and matches carefully before choosing Replace All.

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.