To search in Excel on Windows, press Ctrl+F, type the text or value you want, and press Enter or choose Find Next. On a Mac, press Command+F. Excel takes you to a matching cell; you can narrow the search to a worksheet or the whole workbook using the search options.
This guide covers Excel for Microsoft 365 on Windows. The exact appearance varies slightly by update: Ctrl+F may open a Find pane or the Find tab of the Find and Replace dialog. The core search steps are the same. Save your workbook first if you are about to make broader edits, especially if you plan to use Replace All.
What You’ll Need
- A workbook open in the desktop version of Excel. You can search a worksheet in Excel for the web too, though its controls may look different.
- A word, number, date, or other cell content to look for. If you are unsure how the value is stored or displayed, be ready to try the relevant search options.
- For a workbook-wide search, a saved or otherwise identifiable workbook with the worksheets you want to check. Hidden worksheets may also be included when searching the workbook, depending on the search interface and settings.
Step-by-Step
- Open Find. Click a cell in the worksheet you want to search, then press Ctrl+F on Windows or Command+F on Mac. You can also use Home > Find & Select > Find on Windows. If Excel opens the Navigation pane, use its search box. If it opens the Find and Replace dialog, enter your term in the Find what box.
- Enter a useful search term. Type the word, number, or part of the text you expect to see in a cell. Search is not case-sensitive by default, so searching for “north” can find “North.” For a phrase, enter the words with their spaces. Avoid adding punctuation unless it is actually part of the cell content; a comma, dash, or extra space can make a search return no matches.
- Move to a match. In the dialog, select Find Next, or press Enter when the Find what box is active. Excel selects a matching cell and moves the worksheet view to it. Choose Find Next again to continue through later matches. In the Navigation pane, select a result in the list to jump to that cell. When the search reaches the end, Excel may wrap around to the first match; check the selected cell or result list so you know where the search continued.
- Choose whether to search one sheet or the workbook. In the Find and Replace dialog, select Options if the extra settings are not visible. Set Within to Sheet to search the active worksheet, or to Workbook to search across worksheets. In versions that show workbook-wide results in the Navigation pane, use its workbook search controls. A sheet search is usually the best starting point when you know where the information should be; switch to Workbook if you cannot find it there.
- Check what Excel searches. In the dialog, use Look in to choose whether Excel looks in formulas, values, or notes/comments where those choices are available. Choose Values when you are searching for the displayed result in cells, such as a calculated total. Choose Formulas when you need to find text that is part of a formula, such as a function name or a cell reference. These options affect what Excel matches, so a formula cell can behave differently depending on the setting.
- Refine the match if necessary. Select Match case only when capitalization matters. Select Match entire cell contents when you want a cell containing exactly your search term, rather than a longer entry that includes it. For example, an exact search for “West” will not treat “West Region” as a whole-cell match. Leave both options off for a broader, more forgiving search.
- Review all matches when you need a complete list. In the Find and Replace dialog, choose Find All rather than repeatedly selecting Find Next. Excel displays the matches and their locations; select a listed result to go to that cell. In the Navigation pane, review the result list and click a match. A list is useful when checking for duplicates or confirming that a term appears on several worksheets, but remember that it only reflects the current search scope and settings.
- Close Find without changing the data. Press Esc or close the pane or dialog when you are finished. Finding a cell does not edit its contents. If your next task is to change matching text, use Replace deliberately: on Windows, press Ctrl+H, or open Home > Find & Select > Replace. On Mac, use the Find and Replace controls in Excel; keyboard mappings can vary, so the menu is a dependable route. Review each change before using Replace All.
Common Mistakes
Searching the wrong scope: Find may be set to the active sheet when the target is on another worksheet. Change Within from Sheet to Workbook, or activate the likely worksheet first if you want a focused search.
Using the wrong kind of content: A cell may display a calculated number while containing a formula. If searching the displayed number does not work, check whether Look in is set to Values; if you are looking for formula text, try Formulas instead. The formula bar can help you see what a selected cell actually contains.
Leaving a restrictive option selected: Match case and Match entire cell contents can exclude results you expected to find. Turn them off for a general search, then enable them only when needed. Also check whether a previous search left a format filter active; in the dialog, use the format controls or clear the search format before trying again.
Confusing Find with Go To: Ctrl+F searches for content. Ctrl+G or F5 opens Go To, which is for jumping to a cell address or named range such as B25, not for locating a word in cell text.
Using Replace All too quickly: Find and Replace can change many cells at once. A short term may match parts of longer entries, and workbook-wide scope can affect several sheets. Use Find All first, verify the matches, and save a copy before making a large replacement.
Tips
- Search a distinctive fragment. If a full phrase might have different spacing or punctuation, try a unique word from it. You can then inspect the surrounding cell content.
- Use wildcards for uncertain text. In Excel Find, an asterisk (
*) can stand for any number of characters, and a question mark (?) can stand for one character. For example,Mar*can find entries beginning with “Mar.” To search for a literal asterisk or question mark, put a tilde before it, as in~*. Wildcards broaden the search, so inspect the results rather than assuming every match is relevant. - Repeat the last search quickly. On Windows, Shift+F4 repeats the last Find Next search in Excel. This is handy when stepping through matches after you have closed the search controls. If it does not repeat in your setup, reopen Find with Ctrl+F and continue from there.
- Keep the active cell in mind. Find normally searches the current worksheet, not just the cell you clicked. However, if you selected a range before opening Find, results may be limited to that selection. Click one cell to remove a range selection when you intend to search the full sheet.
- Use Find All for an audit. If you are checking whether a label, code, or spelling variant appears more than once, a results list is easier to review than moving through matches individually. Record the worksheet and cell addresses of important hits before editing them.
- Try a simpler query before changing data. If a search fails, remove extra spaces or punctuation from the term and relax exact-match settings. Once you find the intended cells, decide whether a targeted edit or Replace is safer.
Troubleshooting
Ctrl+F does nothing or opens another feature: Click inside the worksheet grid first, then try Ctrl+F again. If a cell is being edited, press Esc to leave edit mode before opening Find. On a Mac, use Command+F. If a laptop function-key setting interferes with a shortcut, use the ribbon path Home > Find & Select > Find instead.
Excel says it cannot find the text: Confirm the spelling and check for leading or trailing spaces in the cell. Search a shorter, distinctive fragment. Turn off Match case and Match entire cell contents, and check whether the search is limited to a selected range or the wrong sheet. If the target is a formula result, set Look in to Values; if you are searching the formula itself, try Formulas.
The result is not where you expected: Check the worksheet name and cell address in the result list or status area. If the search scope is Workbook, Excel may take you to a different tab. If the match is inside a longer entry, turn on Match entire cell contents only when you want an exact cell-level match; otherwise leave it off.
Find All or the options are missing: The Navigation pane and the traditional Find dialog do not present every control in the same way. Open Find from Home > Find & Select to reach the dialog when available, then expand Options. If using Excel for the web, switch to the desktop app for the full set of desktop search controls.
Replace changed something unintended: Press Ctrl+Z on Windows or Command+Z on Mac promptly to undo a replacement, provided you have not performed an action that clears the undo history. For a large or important replacement, make a separate copy of the workbook first; review matches with Find All and use individual Replace actions when you need control.
Frequently Asked Questions
What is the keyboard shortcut to search in Excel?
On Windows, press Ctrl+F. On Mac, press Command+F. Type your search term, then move through the matches using Find Next or the result list.
How do I search every sheet in an Excel workbook?
Open Find, show the options in the dialog if needed, and set Within to Workbook. In the Navigation pane, use the workbook-wide search option if it appears in your version. Check the sheet names beside results to confirm where each match is located.
Can I search for part of a word or phrase?
Yes. Enter the fragment you want to find and leave Match entire cell contents turned off. Excel can find that fragment within a longer cell entry. You can also use wildcards: * for any number of characters and ? for one character.
How do I find a number that appears in a formula result?
In the Find dialog, set Look in to Values when that option is available. If the number is part of the formula itself rather than the displayed result, choose Formulas. Formatting, rounding, and the underlying stored value can differ from what a cell appears to show.
Does Ctrl+F replace text in Excel?
No. Ctrl+F opens Find. To replace text, press Ctrl+H on Windows or open the Replace controls from the ribbon. On Mac, use Excel’s Find and Replace menu controls if the shortcut differs in your configuration. Check the scope and matches before choosing Replace All.
Can I search in Excel for the web?
Yes. Use the browser version’s Find controls or its available keyboard shortcut to search the open worksheet. The desktop app may offer additional scope and search options, so use Excel for Microsoft 365 on Windows or Mac if you need more control over formulas, workbook-wide search, or replacement.
Related
- How to Paste in Excel and Keep Formatting
- How to Paste in Excel Only Visible Cells Without Hidden Rows
- Paste in a Filtered List in Excel Without Hidden Rows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Table Repeat Header Row: What You Can DoExcel tables do not have a setting that repeats their header row on every printed page. To print…
- Add an Image Watermark in Word: A Clear Step-by-Step GuideTo add an image watermark in Microsoft Word for Microsoft 365 on Windows, open the Design tab, choose…
- Search Excel for Duplicate Entries: Methods That WorkTo search Excel for duplicate entries, select the cells you want to check, then choose Home > Conditional…
- Excel Not Responding? Causes and FixesIf Excel says “Not Responding,” first give it a moment: a large calculation, refresh, or file operation can…
- How to Extract a Filtered List in ExcelTo extract matching rows in Excel, turn on filtering with Data > Filter, apply your criteria, then copy…
- Weekly Meal Planner Spreadsheet: Build a Useful PlanA weekly meal planner spreadsheet is a simple grid for deciding what to eat, organizing recipes and turning…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.