To search an Excel worksheet, press Ctrl+F in Excel for Microsoft 365 on Windows, type the text or number you want, then press Enter or choose Find Next. On a Mac, use Command+F. Excel highlights a matching cell, and you can search again to move to the next match. Click one cell first if you want to avoid limiting the search to a selected range.
This shortcut is useful for locating names, amounts, dates, labels, or other content in a long sheet without scrolling. The steps below focus on the desktop version of Excel for Microsoft 365 on Windows. The basic shortcut is similar on Mac and Excel for the web, with a few interface differences noted where they matter.
What You’ll Need
- An Excel workbook open in Microsoft Excel. If you use Excel for the web, open the workbook in your browser.
- A word, number, or other text you expect to find. If you are unsure of the exact spelling, you can search for a distinctive part of it.
- Access to the worksheet or workbook you want to search. If it is protected, you can usually search its contents, but editing or changing the sheet may be restricted.
Step-by-Step
- Open the worksheet and set the search area. Go to the sheet where you expect the result. If a range of cells is selected, Excel may search only within that selection. Click a single cell, such as A1, to make it clear that you want to search the whole active worksheet rather than just a highlighted block. If you want to search a particular range, select that range instead.
- Open Find. Press Ctrl+F on Windows. Excel opens the Find tab of the Find and Replace dialog. You can also use Home > Find & Select > Find on the ribbon. On a Mac, press Command+F; the Find interface may look different, but you can enter a search term and move through matches in the same way.
- Enter a search term. Type the word, part of a word, or number in the Find what box. For example, entering North can locate a cell containing North Region as well as one containing only North, unless you turn on the whole-cell matching option. Search is generally not case-sensitive by default, so north can find North.
- Move to a match. Press Enter or select Find Next. Excel selects the matching cell in the worksheet. Press Enter again, or choose Find Next again, to move through further matches. If you reach the end of the search area, Excel wraps around to the beginning, so check the cell address to tell whether you have looped back.
- Review all matches when needed. In the Find dialog, choose Find All to list every matching cell. The results include cell references, which helps when the same term appears many times. Select a result in the list to jump to that cell. This is often faster than pressing Find Next repeatedly in a large worksheet.
- Choose the search scope and direction. If the Find dialog is compact, select Options to show additional settings. Set Within to Sheet to search the active worksheet or Workbook to search all worksheets in the open workbook. The Search setting controls whether Excel checks by rows or by columns; it changes the order in which matches are visited, not which cells are included.
- Choose what Excel looks at. In the expanded options, check Look in. Searching in Formulas can find text or numbers that appear in formulas as well as ordinary cell entries. Values searches displayed results, which is useful when a formula produces the text or number you are looking for. Depending on the Excel version and workbook content, options for notes or comments may also appear. If you get unexpected results, try a different Look in setting.
- Refine the match if necessary. Select Match case if capitalization must be identical, or Match entire cell contents if the cell must contain only the search term. For example, searching for East with entire-cell matching will not treat East Office as a match. Turn off either option when you want a broader search.
- Close Find and continue working. Close the dialog when you have found the right cell. The selected cell remains active, so you can inspect its row and column or edit it if appropriate. Press Esc to close the Find dialog. On Excel for the web, use Ctrl+F or the workbook’s Find command; if the browser’s own search appears, use Excel’s Home ribbon search instead so results are found in the workbook, not just in visible page text.
Common Mistakes
Searching only a selected range by accident. If you highlighted cells before opening Find, Excel may confine the search to that selection. Click a single cell and search again to check the entire active sheet. Conversely, deliberately selecting a range is helpful when you want to avoid matches elsewhere on the sheet.
Looking for a displayed result in formulas. A cell might show a word or number because of a formula, even though that result is not typed into the cell. If searching under Formulas does not locate the displayed result, change Look in to Values. The opposite can happen too: a search for part of a formula may require looking in Formulas.
Using whole-cell matching without realizing it. With Match entire cell contents enabled, the search term must match the complete cell content. A search for 245 will not find a cell containing 2450 or a sentence that includes 245. Turn off the option if you need a partial match.
Assuming the search is case-sensitive. Excel normally ignores capitalization during a search. If you need to distinguish a label such as ID from Id, enable Match case. Otherwise, leaving it off usually makes a search more forgiving.
Confusing Find with Replace. Ctrl+H opens Replace, which can alter workbook data. Use Ctrl+F when you only want to locate content. Before replacing multiple matches, review the search term and replacement text carefully, especially if a short term could appear in unrelated words or formulas.
Tips
- Search for a distinctive fragment when you do not know the full entry. A surname, part of an order number, or unusual word is often easier to find than a common word such as “date.”
- For multiword phrases, try the exact phrase first. If Excel returns no result, search for a shorter part because the cell may use different spacing, punctuation, or wording.
- Use Find All when comparing repeated entries. The results list gives you a quick way to jump between matching cells and inspect their surrounding rows.
- Search the workbook when you cannot remember which worksheet contains the information. Set Within to Workbook; otherwise, a successful search on the wrong sheet may misleadingly report no matches.
- Excel supports wildcard characters in Find. An asterisk (
*) can stand for any number of characters, and a question mark (?) can stand for one character. To search for an actual asterisk or question mark, put a tilde before it, such as~*. Use wildcards carefully: a broad pattern can return many unrelated cells. - If you repeat the same search later, the Find dialog may retain earlier settings, including Match case or the Look in choice. Check the options rather than assuming they have returned to their defaults.
- In a filtered list, a match may be in a row that is currently hidden by the filter. Clear or adjust the filter if you suspect the value exists but cannot see the matching row.
Troubleshooting
Excel says no matches were found. Check spelling, spaces, punctuation, and the selected range first. Then confirm that Within is set to the intended sheet or workbook and that Look in is appropriate. Turn off Match case and Match entire cell contents temporarily to broaden the search. If the value is produced by a formula, try Values; if you are looking for formula text, try Formulas.
Find Next selects an unexpected cell. Check the address of the selected cell and the search direction setting. The search may have wrapped from the end of the sheet to the beginning, or another match may appear earlier than expected in the selected order. Use Find All to see the matching cell references together, then select the result you need.
Only part of the workbook is being searched. If Excel is searching a highlighted block, click a single cell and run Find again. If it is searching only one worksheet, expand the Find options and change Within from Sheet to Workbook. Searching a workbook includes its worksheets, but it does not search separate workbooks that happen to be open.
The shortcut opens the wrong search box. In Excel for the web, a browser can sometimes handle a keyboard shortcut before the workbook does. Click inside the worksheet and try again; if the browser’s find bar still appears, use Excel’s Home ribbon and choose its Find command. In desktop Excel, make sure the Excel window is active before pressing the shortcut.
The result is difficult to identify. Excel selects the matching cell, but the selection may be outside the visible area or the sheet may be zoomed out. Check the Name Box near the formula bar for the selected cell reference, then use the row and column headings to orient yourself. Find All can also show the reference in its results list.
Frequently Asked Questions
What is the shortcut to search in Excel?
On Windows, press Ctrl+F. On a Mac, press Command+F. These open Excel’s Find feature so you can enter a term and move to matching cells.
How do I search every sheet in an Excel workbook?
Open Find, show its options, and change Within to Workbook. Then use Find Next or Find All. The default scope is often the active sheet, so check this setting if a search returns no results.
Can I search for part of a cell’s text?
Yes. Enter the part you remember and leave Match entire cell contents turned off. You can also use wildcards: * represents any number of characters, while ? represents one character.
Can Excel find a number shown by a formula?
Yes. In Find options, set Look in to Values to search the displayed result. Choose Formulas when you want to find text or numbers contained in the formula itself.
Does Ctrl+F search hidden or filtered rows?
It can locate content in rows that are hidden by a filter, but those rows may not be visible when Excel selects the match. Adjust or clear the filter to inspect the row and confirm the result.
Can I search for a word with exact capitalization?
Yes. Open the Find options and select Match case. With that option off, Excel normally finds the term without distinguishing uppercase and lowercase letters.
Related
- How to Paste a Link in Excel as Plain Text, Not Hyperlink
- How to Paste in Excel Without Overwriting Existing Data
- How to Paste in Excel With 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
- How to Change Font Size in Outlook Email ViewTo make messages easier to read in Outlook, adjust the reading-pane zoom in classic Outlook for Windows, or…
- Excel Wrap Text Shortcut: Keys, Ribbon, and FixesIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, W—one key…
- Excel Shortcut to Select Visible Cells in a Filtered RangeIn Excel for Microsoft 365 on Windows, select the range you want and press Alt+; (Alt plus semicolon)…
- Name Badge Template in Word: Create One Step by StepCreate a reusable name badge template in Word by setting up a page and sizing a table to…
- Ctrl+E in Excel: Flash Fill Shortcut and How It WorksIn Excel for Microsoft 365 on Windows, Ctrl+E runs Flash Fill: it detects a pattern in your examples…
- How to Hide Page Break Lines in Excel on a WorksheetTo hide page break lines in Excel for Microsoft 365 on Windows, switch to View > Normal, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.