To find a word in Excel, press Ctrl+F on Windows, type the word in the Find what box, then choose Find Next or Find All. Excel searches the current worksheet by default; use Options to search the whole workbook, match a complete cell, or change what Excel checks. You only need an open workbook and the word or text you want to locate.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the workbook you want to search open. The steps are similar in many recent desktop versions of Excel.
- A word, phrase, number, or part of a cell entry to search for. You do not need to know which cell contains it.
Step-by-Step
- Open Find. Click a cell in the worksheet you want to search, then press Ctrl+F. You can also go to Home > Find & Select > Find. Excel opens the Find and Replace dialog with the Find tab selected. If you have selected a range of cells, Excel may limit the search to that selection, so click a single cell first if you want to search the entire sheet.
- Enter the word or phrase. Click in the Find what box and type the text exactly as you want to search for it. For example, typing
Orchardcan locate cells containing “Orchard Lane” as well as a cell containing only “Orchard,” unless you turn on Match entire cell contents. The search is not case-sensitive by default, so it generally finds “orchard” too. - Choose the search scope. Select Options if the extra settings are not already visible. The Within menu controls where Excel looks: choose Sheet to search the active worksheet, or Workbook to include all worksheets in the open workbook. If you select Workbook, Excel can move to a match on another sheet. The dialog shows the sheet name for each result when you use Find All.
- Check what Excel searches. In Look in, choose the kind of content to search. Formulas is useful when you need to find text in formulas as well as ordinary entries; Values searches the displayed results of formulas and cell contents. Depending on the Excel version and workbook, you may also see options for Comments or Notes. If the word appears on the screen but is not found, try another Look in option.
- Decide whether the match must be exact. Leave Match entire cell contents unchecked to find the word within longer entries. Turn it on when the whole cell must equal the text you typed. For example, a search for
Eastcan find “East Warehouse” when the option is off, but should only return a cell whose complete content is “East” when it is on. Use Match case only when uppercase and lowercase letters must match exactly. - Find the first result. Click Find Next to select the next matching cell. Excel moves the active-cell outline to that result, and the worksheet may scroll to show it. Click Find Next again to move through additional matches. The search can wrap around to the beginning after reaching the end, so pay attention to the cell address and sheet name if you are checking for duplicates.
- Review every match if needed. Click Find All to show a list of matching cells in the dialog. Select a result in the list to go to that cell. This is helpful when the same word appears many times or when you are searching the whole workbook. If Find All returns no results, confirm the spelling, scope, and Look in setting before assuming the word is absent.
- Close the dialog when you are finished. Press Esc or click the dialog’s close button. Closing Find does not change cell contents; it only ends the search. If you only want to locate a word, do not use the Replace tab or type replacement text into the Replace with box.
Mac and web versions: In Excel for Mac, press Command+F to open Find, then use the dialog’s options to set the scope and matching rules. In Excel for the web, use Home > Find & Select > Find if available in your ribbon, or press Ctrl+F in Windows and Command+F on Mac. The browser or web version can present search controls differently, so check that you are using Excel’s Find feature rather than the browser’s page-only search if you need to search workbook cells or change options.
Common Mistakes
Searching only the active sheet by accident. A search limited to Sheet will not report matches on other tabs. Set Within to Workbook when the word could be anywhere in the file. Conversely, Workbook may return results from an old or unrelated sheet, so use Sheet when you know which tab contains the information.
Turning on Match entire cell contents unnecessarily. This setting excludes cells that contain extra words, punctuation, or spaces. If you are looking for “North” and the cell says “North Region,” an exact-cell search will miss it. Turn the setting off to search inside longer cell entries.
Expecting a case-sensitive search by default. Excel normally treats upper- and lowercase letters as equivalent in Find. If you need to distinguish “ID” from “Id,” select Match case. Remember that this can also exclude otherwise relevant matches.
Searching the wrong content type. A cell with a formula might show a word as its result even though the formula itself contains different text, or a formula may include a word that is not visible in the cell. Look in determines what is searched. Try both Formulas and Values when you are unsure whether the visible result or the underlying expression contains the text.
Using Replace when you only mean to locate. Find Next and Find All do not edit your data. Replace and Replace All do. A broad Replace All can change many cells at once, especially if Match entire cell contents is off. Use Find All to inspect matches first and save a copy before making bulk replacements.
Tips
- Search for part of a word. Enter a distinctive fragment when you are unsure of the full entry. A search for
orchcan find “orchard,” “Orchard Lane,” and other entries containing that sequence, subject to the selected search options. - Use wildcards for uncertain text. In Excel’s Find what box, an asterisk (*) represents any number of characters and a question mark (?) represents one character. Searching
sm?thcan match “smith” or “smyth.” To find an actual asterisk, question mark, or tilde, put a tilde before it:~*,~?, or~~. - Search a selected range deliberately. If you want to look only in a particular block, select that range before opening Find. If Excel returns too few results, clear the selection by clicking a single cell and run the search again. This avoids mistaking a range-limited search for a workbook-wide search.
- Use Find All to compare duplicates. The results list makes it easier to see which sheets and cell addresses contain the text. Click individual results to inspect nearby data before editing anything. This can also help you distinguish a true duplicate from a word used in a different context.
- Remember that formatting affects appearance, not necessarily content. A cell may look blank because its text is hidden by formatting, its column is narrow, or the font color blends into the background. Search can still locate underlying cell content. Widen the column or inspect the formula bar after navigating to a match.
- Keep the search simple at first. Start with the main word and the default settings. Add Match case, Match entire cell contents, or a wildcard only when the basic search returns too many results or the wrong ones. Each extra condition can rule out a match you wanted.
Troubleshooting
Excel says no matches were found. Check for a spelling difference, extra punctuation, or a space before or after the word. Try a shorter fragment, turn off Match entire cell contents and Match case, and check whether Within is set to the correct sheet or workbook. Then try another Look in choice, especially if the relevant cells contain formulas.
The word is visible, but Find does not locate it. First check whether the visible text is a formula result or a value. Switch between Formulas and Values in Look in and search again. If the displayed text is produced by a formula, the result and the formula itself may contain different text. Also confirm that you did not select a small range before opening Find.
Find stops on the wrong sheet or returns too many results. When Within is set to Workbook, matches can come from other tabs. Use Find All to check the sheet and cell address, or change Within to Sheet. If results seem unrelated, turn on Match entire cell contents or search for a longer, more distinctive phrase.
A match seems to be missing from a filtered or hidden area. Clear worksheet filters temporarily, unhide relevant rows or columns, and run Find All again. A filtered view can make it difficult to see where a result is, even when the cell remains in the worksheet. After navigating to a match, check the row and column labels and remove filters if you need to inspect its context.
The dialog remembers old settings. Find can retain options from a previous search, such as Match case, a format condition, or a particular Look in choice. Open Options and review every setting. If the search is still behaving unexpectedly, clear any format restriction using the format control in the dialog, then try again with a simple text search.
Ctrl+F opens something unexpected. In a browser or Excel for the web, the shortcut may open the browser’s Find bar instead of the Excel search controls. Use the Excel ribbon’s Find command to search cells and access workbook-wide options. In desktop Excel for Mac, use Command+F; on Windows, use Ctrl+F.
Frequently Asked Questions
How do I search every sheet in an Excel workbook?
Open Find with Ctrl+F on Windows or Command+F on Mac, select Options, set Within to Workbook, enter the word, and choose Find All or Find Next.
Can I find a word inside a longer cell entry?
Yes. Leave Match entire cell contents unchecked. Excel can then find the search text within a longer phrase or entry.
Can I make Excel search with capital letters matching exactly?
Yes. Open Options in the Find dialog and select Match case. For example, a case-sensitive search for “ID” will not treat “id” as the same text.
Can Find search formulas as well as cell values?
Yes. Use the Look in menu to choose Formulas or Values. Try both if you are not sure whether the text is in a formula or in the result displayed by the cell.
How do I find a question mark or asterisk as a character?
Excel uses ? and * as wildcards in Find. Add a tilde before the character to search for it literally: enter ~? for a question mark or ~* for an asterisk.
Does finding a word change my workbook?
No. Find Next and Find All only locate matching cells. The workbook changes only if you edit a cell or use Replace or Replace All.
Related
- Extract Text from an Image in Excel with Data from Picture
- Extract Rows in Excel to a New Sheet: Step-by-Step
- GST Number to PAN in Excel: Extract the 10-Character PAN
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Change All Caps to Lowercase in Excel: A Practical GuideYes. In Microsoft Excel for Microsoft 365, enter =LOWER(A2) in a neighboring cell to turn the text in…
- How to Split a Cell in Excel: Easy Ways to Separate TextThe easiest way to split text in an Excel cell is to select it, then choose Data >…
- How to Share a Vacation Calendar in Outlook with OthersTo share a vacation calendar in Outlook, create or select a calendar, add your time-away dates, then use…
- Excel File Name Extensions: .xlsx, .xlsm, .xls and MoreThe standard Excel file name extension is .xlsx, the default for workbooks in Microsoft Excel for Microsoft 365…
- Conditional Formatting for Errors in Excel: How to Do ItTo highlight error cells in Excel, select the range, choose Home > Conditional Formatting > New Rule >…
- Embed Video in PowerPoint and Play It AutomaticallyYes. In PowerPoint for Microsoft 365, select the video, open the Playback tab, and set Start to Automatically.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.