In Excel for Microsoft 365 on Windows, press Ctrl+F to find text or numbers in a worksheet. On a Mac, press Command+F; enter your search term and use the Find controls to move through matching cells.
The Find shortcut and what it opens
Ctrl+F is the quickest way to open Excel’s Find and Replace window on Windows. It takes you to the Find tab, where you can enter a word, number, or other text to search for. Press Enter or choose Find Next to jump to a matching cell. Pressing the shortcut again while the window is open may move the focus back to the search field, depending on the dialog state.
You can also open the command from the ribbon: select Home > Find & Select > Find. The keyboard shortcut is useful when you are already working in a sheet, while the ribbon path can help if you forget the keys or prefer using menus. Find locates existing content; it does not change the workbook unless you switch to the Replace tab and perform a replacement.
Excel searches the active worksheet by default. If the workbook is large, the search settings matter: a term might be present but not found because Excel is looking in a different scope or checking formulas rather than displayed results.
How to find a value step by step
- Click a cell in the worksheet you want to search. If you want to limit the search to a particular range, select that range first.
- Press Ctrl+F on Windows or Command+F on Mac.
- Type the word, number, or characters you want to locate in the Find field.
- Choose Find Next or press Enter to go to the next match. Choose Find All if you want a list of matching cells.
- Close the Find window when you are done. The selected match remains active in the worksheet.
For example, suppose a product list contains the word “cable” in several rows. Searching for cable takes you to a matching cell; choosing Find Next moves to another match. Find All displays the matching references together, which is often more useful when checking whether a term appears once or many times. If the search reaches the end of the range or sheet, Excel wraps around and continues from the beginning.
Choose the right search scope
The Find window’s Options control expands settings that determine where and how Excel searches. Within lets you search the current sheet or the whole workbook. Choose Workbook when you need to find a term across multiple tabs; otherwise, a search can appear to miss content simply because it is on another sheet.
You can also choose whether Excel searches by rows or by columns. This setting affects the order in which matches are visited, not which cells qualify. A row-oriented search moves across a row before proceeding to the next, while a column-oriented search works down a column first. For most ordinary searches, the default direction is adequate.
When you select a range before opening Find, Excel can restrict the search to that selection. This is handy in a wide table when you only want to inspect one column or a block of cells. If you intended to search the whole sheet but had a range selected, click a single cell and search again, or select the broader range you need.
Search formulas, displayed values, and exact matches
The Look in setting determines what Excel checks. Searching in formulas can locate text that appears in a formula itself, while searching in values can locate a result displayed in a cell. Consider a cell that displays 250 because it contains a formula: a search for part of that formula and a search for 250 are different searches. If a result is not turning up, check this setting before assuming the cell is absent.
Find also offers options such as Match case and Match entire cell contents. Match case distinguishes uppercase and lowercase letters. Match entire cell contents prevents a search for cat from matching a cell containing catfish or a longer phrase. Leave that option off when you want partial matches, such as finding every cell that includes a surname within a longer entry.
Excel may retain Find settings from a previous search, so check the options when results seem surprising. A search that worked on one sheet might use a different scope, matching rule, or Look in choice the next time you open Find.
Use wildcards for partial or variable text
Find supports wildcard characters when you need to search for patterns rather than one fixed phrase. The asterisk (*) represents any number of characters, and the question mark (?) represents one character. For instance, searching for sam* can match cells containing text that starts with sam, such as Sample or Samantha, if the other Find options allow partial matches.
Wildcards can be useful when spellings or codes vary slightly. Searching for INV-?? can match a text pattern with two characters after the hyphen, such as INV-04. It will not match every possible invoice format, so consider the actual content and whether Match entire cell contents is enabled.
If you need to search for a literal asterisk or question mark instead of using it as a wildcard, put a tilde before it. For example, search for ~* to find an asterisk character. A tilde can also escape itself: use ~~ to search for a literal tilde. This distinction matters in sheets containing codes or notes that use these symbols as ordinary characters.
Find versus Replace
Find only navigates to matching content. To change matches, open the Replace tab in the same window, or use Ctrl+H on Windows. On Mac, the corresponding shortcut is generally Control+H in Excel; shortcut behavior can vary with keyboard layout and macOS settings, so the ribbon route is a reliable alternative. You can also select Home > Find & Select > Replace.
Replace lets you enter a search term and replacement text, then use Replace to handle a match at a time or Replace All to change every match in the chosen scope. Take care with Replace All: a short term can occur inside longer words, and the scope might be the entire workbook rather than the current sheet. Review the selected scope and matching options before making a broad change. If the edit is wrong, use Undo promptly; saving, closing, or making other edits can complicate recovery.
If your aim is to inspect a result without changing it, stay on Find. If you need to change a repeated label, Replace is faster, but a one-at-a-time review is safer when the term could occur in different contexts.
Windows, Mac, and Excel for the web
On Windows desktop Excel, the standard shortcut is Ctrl+F. On Mac desktop Excel, use Command+F. The keys differ because Windows applications commonly use Ctrl for commands, while Mac applications commonly use Command. The Find and Replace controls offer similar core search functions on both platforms, although window layout and some available settings can differ by Excel release.
In Excel for the web, Ctrl+F on Windows or Command+F on Mac is the normal way to start a search in the workbook, though the browser and web app may affect which search interface receives the shortcut. If the browser’s own Find feature appears instead, click inside the worksheet and try the shortcut again, or use Excel’s ribbon search command. Web and desktop versions can differ in advanced options, so use desktop Excel if a particular search setting is unavailable in the browser version.
Keyboard shortcuts can also be intercepted by browser extensions, remote-desktop tools, or operating-system settings. If the expected window does not open, try the ribbon command rather than repeatedly pressing the shortcut. This helps identify whether the problem is with the key combination or with the workbook search itself.
Common problems and quick fixes
- No results appear: Confirm that you are searching the intended sheet or workbook, and check whether a selected range is restricting the search.
- A number is not found: Check Look in. The cell may display a calculated result while its formula contains different text, or the displayed number may use formatting that differs from its stored value.
- Only some matches appear: Turn off Match case or Match entire cell contents if those rules are too restrictive. Check whether a wildcard is changing the meaning of the search.
- Find Next seems to skip a match: Use Find All to list matching cells, then review the search direction and scope. A match may be on another worksheet or outside the selected range.
- The shortcut opens the wrong search box: Click into the worksheet and try again, or open Find through Home > Find & Select > Find.
One common misconception is that Find searches only what is visibly on screen. It can locate cells elsewhere in the searched range or sheet, including cells that require scrolling to see. Another is that a formula result and the formula text are interchangeable: they are not, which is why Look in can change the result.
Frequently Asked Questions
What is the shortcut key for Find in Excel?
Press Ctrl+F in Excel for Microsoft 365 on Windows. On a Mac, press Command+F. Type your search term and choose Find Next or Find All.
How do I find something in the entire Excel workbook?
Open Find with Ctrl+F or Command+F, expand Options, and set Within to Workbook. Then search as usual. This searches across the workbook’s sheets rather than only the active sheet.
Can I find part of a word in Excel?
Yes. Search for the characters you need and leave Match entire cell contents turned off. For example, searching for lane can find a cell containing Delaney if the search settings allow partial matches.
How do I find a value in Excel without replacing it?
Use Ctrl+F on Windows or Command+F on Mac and stay on the Find tab. Find Next moves through matches without editing them; avoid the Replace tab if you do not intend to change cell contents.
Why does Ctrl+F not find a number shown in a cell?
Check the search scope and the Look in option. A displayed number may come from a formula, and a number’s formatting can differ from the underlying value Excel searches. Try Find All and confirm that the correct worksheet is included.
What is the shortcut for Replace in Excel?
On Windows, press Ctrl+H to open Replace. On Mac, Control+H is commonly used, but the ribbon command Home > Find & Select > Replace is available if the shortcut differs on your setup.
Related
- Excel Data Validation List With a Blank Option
- Excel Data Validation List Without a Cell Reference?
- Excel Data Validation List: Can You Select Multiple?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Sort by Date in Google SheetsTo sort dates in Google Sheets, select the entire table, choose Data > Sort range > Advanced range…
- How to Set Out of Office in Outlook on the WebTo set an out-of-office message in Outlook on the web, open Settings, find Automatic replies, turn them on,…
- How to Hide Columns in Excel for the Web: Steps & TipsTo hide columns in Excel for the web, select the column letter or letters, right-click the selection, and…
- Mail Merge Excel to Word: A Practical Step-by-Step GuideTo mail merge Excel data into Word, prepare a workbook with one row per recipient and a header…
- Excel Continually Not Responding? Causes and FixesIf Excel continually says “Not Responding,” first give it a few minutes if it may be calculating, saving,…
- Excel Table Color Schemes: How to Choose and ChangeTo change an Excel table’s color scheme, click inside the table, open Table Design, and choose a style…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.