In Excel for Microsoft 365 on Windows, press Ctrl+F to find text, numbers, or other content in a worksheet. On a Mac, press Command+F. Excel opens the Find tab, where you can search the current sheet, expand the search to the workbook, and adjust how matches are found.
What Ctrl+F Does in Excel
Ctrl+F opens Excel’s Find and Replace dialog with the Find tab active. Type a word, number, or other text in the search box, then choose Find Next to move to a matching cell. Excel selects the cell containing the match, so you can inspect its position and surrounding data. Choose Find All to show a list of matches in the dialog; selecting an entry in that list takes you to its cell.
The shortcut is useful when a worksheet is too large to scan by eye. For example, in a product list, search for “cable” to jump to a matching description. In a budget, search for a particular amount or label. Finding a match does not edit the cell: it only locates content. If you want to change matches, use Replace instead.
Excel generally searches the active worksheet. If you have selected a range of cells, the search may be limited to that selection, so check the selection if expected matches seem to be missing. Clicking a single cell before searching is a straightforward way to avoid unintentionally restricting the search.
Search the Whole Workbook
A workbook can contain many worksheets, and the default search scope may be only the current sheet. To search all sheets, open Find with Ctrl+F, select Options if the additional settings are not visible, and change Within from Sheet to Workbook. Enter the search term and choose Find Next or Find All. The workbook-wide setting is particularly helpful for locating a customer name, code, or label that might appear on several tabs.
For example, imagine a workbook with separate sheets for January, February, and March. Searching for “West” while Within is set to Sheet checks only the active month. Changing Within to Workbook allows Excel to look across the workbook’s worksheets. When a result is selected, Excel switches to the sheet containing that match.
Before searching, it can help to make sure the intended workbook is active and that you have not selected a small cell range. If the workbook has hidden worksheets, keep in mind that a search result is useful only if the sheet and cell are accessible to you; a hidden sheet may need to be unhidden to inspect or edit its contents.
Choose What Excel Searches
The Find dialog’s expanded options help explain why a search can appear to miss visible information. The Look in setting controls whether Excel looks in formulas, displayed values, or notes. In many cases, the default is Formulas. That means a cell displaying a calculated result may be searched according to the formula stored in the cell, rather than only according to the displayed result.
Suppose a cell displays 150 because it contains a formula that adds several amounts. If you search for the result 150 but Excel is looking in formulas, it may not find that cell: the formula text might be something like a SUM expression, not the number 150. Change Look in to Values to search the calculated result instead. Conversely, use Formulas when you need to locate a particular function, cell reference, or piece of formula text.
Excel can also search notes. Notes are the older cell annotations that appear as attached comments; modern threaded comments are a separate collaboration feature and may not behave like ordinary cell contents in Find. If you are looking for an explanation someone added to a cell, check the relevant note or comment feature rather than assuming a normal value search will find it.
Other useful options include Match case, which distinguishes uppercase and lowercase letters, and Match entire cell contents, which requires the cell’s full content to equal the search term. Without the whole-cell option, searching for “net” can find a longer entry such as “Internet sales.” With it enabled, that longer entry is not an exact match.
Use Wildcards for Flexible Searches
Excel’s Find tool supports wildcard characters for text searches. An asterisk (*) stands for any number of characters, including none, while a question mark (?) stands for one character. Wildcards can help when you know only part of a name or want to match a pattern.
- Search for
north*to find text that begins with “north,” such as “North region.” - Search for
gr?yto match a four-character word such as “gray” or “grey.” - Search for
*invoice*to find text with “invoice” somewhere inside it.
These patterns are not regular expressions; they use Excel’s simple wildcard rules. If you need to find a literal asterisk or question mark rather than use it as a wildcard, put a tilde before it. For instance, search for ~* to look for an actual asterisk character. Use ~? for a literal question mark and ~~ for a literal tilde. This distinction matters in data that includes symbols, file patterns, or product codes.
Find, Replace, and Go To Are Different
Ctrl+F is for locating content. To search for content and substitute another value, use Ctrl+H on Windows to open the Replace tab. On Mac, the keyboard equivalent is usually Control+H in Excel, though menu and keyboard behavior can depend on the macOS keyboard settings. Review matches carefully before choosing Replace All, especially if the term appears in formulas, labels, or several sheets. The Find and Replace dialog provides options for controlling the search scope and what Excel looks in.
Find is also different from Go To. Press Ctrl+G or F5 on Windows to open Go To, then enter a cell reference such as D250 to jump directly to that location. Go To is best when you already know the address; Find is better when you know some of the cell’s content but not where it is. On Mac, use Control+G or F5 where supported by your keyboard and Excel setup, or use the Edit menu’s Find and Go To commands.
These tools solve different problems: use Find to locate a word or value, Replace to change matching content, and Go To to navigate to a known address. A search for a person’s name, for example, is a Find task; changing an old department label throughout a workbook is a carefully reviewed Replace task; jumping to cell K500 is a Go To task.
Common Search Problems and Fixes
If Ctrl+F appears not to work, first check whether Excel is the active application and whether a dialog or another program has captured the shortcut. On some laptops, function keys and other system shortcuts can also behave differently depending on keyboard settings. You can still open Find from Excel’s ribbon or menu if the keyboard shortcut is unavailable.
- No match appears: Check the Within and Look in settings, then confirm that Match case or Match entire cell contents is not excluding the result.
- A displayed number is not found: Try Look in: Values, particularly if the cell is calculated by a formula.
- Only part of the sheet is searched: Click a single cell to clear an accidental multi-cell selection, then try again.
- The search finds an unexpected longer phrase: Turn on Match entire cell contents if you want an exact cell match.
- Results seem to continue from an earlier search: Reopen Find and review the search term and options; Excel can retain settings from a previous search.
Formatting can affect searches too. The Find dialog includes a Format option, which can restrict results to cells with specified formatting. If a format criterion has been applied unintentionally, clear it through the format controls in the dialog before searching again. A plain search usually needs no format restriction.
Finally, be clear about whether the content is a constant or a formula result. A cell can visibly show a date, rounded number, or formula output that differs from the underlying stored value. Try switching between Formulas and Values, and consider the cell’s number format when a result looks surprising.
Excel for Mac and Excel for the Web
On Excel for Mac, the usual shortcut for Find is Command+F, not Ctrl+F. The dialog offers similar search options, though the appearance and exact placement of controls can vary by Excel release. Use the dialog’s options to change the scope or search formulas and values. For Replace, Excel for Mac commonly uses Control+H; if that shortcut conflicts with a system setting, open the Replace command from Excel’s menus.
Excel for the web also provides Find, and Ctrl+F is commonly used on Windows. However, a browser may intercept that shortcut or display its own page-search feature depending on the browser and context. If the browser’s search bar appears instead of Excel’s, use the Find command in the Excel interface. This distinction matters: browser Find searches text currently rendered on the page, while Excel’s Find searches spreadsheet content using Excel’s search options.
For accessibility or when a shortcut is inconvenient, use the Find command from Excel’s ribbon or menu. The precise ribbon layout can vary with window size and interface updates, but the search dialog’s Find and Replace controls remain the relevant tools. A keyboard shortcut is faster once familiar, but it is not the only way to reach the feature.
Frequently Asked Questions
What is the shortcut to find something in Excel?
Press Ctrl+F on Windows. On a Mac, press Command+F. Type the text or number in the Find dialog and select Find Next.
How do I search all sheets in an Excel workbook?
Open Find, show its options if needed, and change Within from Sheet to Workbook. Then search as usual. The Workbook choice searches across the workbook’s worksheets rather than only the active sheet.
How do I find a value produced by a formula?
In the Find dialog, change Look in to Values to search calculated or displayed results. Choose Formulas when you want to search the formula text itself.
Can I search for only an exact cell match?
Yes. In Find options, select Match entire cell contents. Excel will then look for cells whose complete contents match your search term instead of finding it as part of a longer entry.
What is the difference between Ctrl+F and Ctrl+H?
Ctrl+F opens Find to locate content. Ctrl+H opens Replace so you can locate content and substitute something else. Check the search scope and matches before using Replace All, which can alter many cells at once.
Why does Ctrl+F open my browser’s search bar?
In Excel for the web, the browser can sometimes capture Ctrl+F. Use Excel’s own Find command in the interface if the browser search appears; the browser searches page text, while Excel Find searches worksheet content.
Related
- How to Unhide a Sheet in Excel With a Shortcut
- How to Unhide Rows in Excel Using Keyboard Shortcuts
- Unhide Rows in Excel: Shortcut Keys and Other Methods
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- COUNTIF Not Including Zero? Excel Formula ExamplesIn Excel for Microsoft 365, use =COUNTIF(A2:A20,"<>0") to count cells whose values are not zero, assuming your data…
- PV vs NPV in Excel: Which Function Should You Use?Use Excel’s PV function to find the present value of regular payments or a future balance; use NPV…
- Excel: Sum VLOOKUP Values Across Multiple Matching RowsTo total every row that matches a lookup value, use SUMIF, not a regular VLOOKUP: with the matching…
- Excel Text Filter Wildcards: How to Use ThemIn Excel for Microsoft 365 on Windows, text-filter wildcards let you match patterns: use * for any number…
- XLOOKUP to Compare Two Sheets in Excel Step by StepIf Sheet1 has IDs in A2:A100 and Sheet2 has IDs in A2:A100, enter this in Sheet1 cell B2…
- Excel Filter Shortcut Key: Apply, Toggle, and Use FiltersIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for the selected…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.