Excel Find Shortcut: How to Search a Worksheet

In Excel for Microsoft 365 on Windows, press Ctrl+F to open Find, type the text or number you want, then choose Find Next or Find All. On a Mac, use Command+F. The shortcut opens Excel’s search controls; it does not immediately search every workbook or guarantee that the first match is the one you need.

Excel’s Find feature can locate text, numbers, and—in the right search mode—content inside formulas. Knowing how to set the search area, match rules, and search direction makes the shortcut much more useful, especially in large sheets.

What Ctrl+F does in Excel

In the Windows desktop version of Excel, Ctrl+F opens the Find and Replace dialog on its Find tab. Enter a search term in the Find what box and select Find Next to move to a matching cell. Each time you select Find Next, Excel moves to another match. Select Find All to display a list of matches instead of moving through them one at a time.

You can also open the same search controls from the ribbon: choose Home > Find & Select > Find. The keyboard shortcut is generally quicker, while the ribbon route is useful when you cannot remember the key combination or want to see where the command lives.

Find searches the active worksheet by default. It usually matches a search term wherever it appears in a cell, so searching for west can find a cell containing West Region. Search is not case-sensitive by default, and it does not require the cell to contain only the search term. Both behaviors can be changed in the options.

How to find a value step by step

For a straightforward search in a worksheet, use this sequence:

Press Ctrl+F on Windows, or Command+F on Mac.
Type a word, phrase, or number in the Find what box. For example, enter overdue to look for cells that contain that word.
Select Find Next to jump to a match. Select it again to move to the next one.
Select Find All if you want a list of matching cells. Select an item in the results to jump to that cell.
Close the search dialog or pane when you are finished. The matching cell is selected, so you can inspect or edit it.

If you already know the approximate location, click a cell in that part of the sheet before searching. This does not necessarily restrict the search to that area; the search scope is controlled separately. If you deliberately select a range before opening Find, Excel can search within that selection. Check the results if the selection contains multiple separate areas or if the search returns fewer matches than expected.

Search one sheet or the whole workbook

The Within setting controls where Excel looks. The default is usually the active sheet. Change it to Workbook when you need to search across the sheets in the current workbook—for example, to find a customer name that might appear on a monthly tab, a summary tab, or an archive tab. This setting applies to the workbook you are working in, not every workbook that happens to be open.

Use the narrower sheet scope when you know which worksheet contains the information. It keeps the results focused and makes it easier to tell where a match came from. For a workbook-wide search, Find All is often more convenient than repeatedly selecting Find Next: the results list shows matching sheet and cell locations, letting you jump directly to a particular result.

The dialog also includes a Search setting, commonly offering By Rows or By Columns. This controls the order Excel follows as it searches; it does not change which cells are included. Use the default in most cases. If you are stepping through a carefully arranged table and want matches to be considered down columns rather than across rows, change the direction and then check the order of the results.

Search displayed values or formula text

One important option is Look in. When it is set to Formulas, Excel can find text that appears in a formula itself. When it is set to Values, it searches the result displayed by the cell. This distinction explains why a search sometimes misses something that appears visibly on the sheet.

For example, imagine cell C2 contains a formula that combines the word North with a value from another cell, and the displayed result is North Depot. Searching for North may find the cell when Excel is looking at its displayed value. Searching for a piece of the formula’s actual text may require looking in Formulas instead. The formula bar shows the formula when the cell is selected; the worksheet cell normally shows its calculated result.

Excel’s Find options may also include Notes and Comments, depending on the version and the type of annotations in the workbook. Choose the appropriate option if you are trying to locate text in a note or comment rather than in a cell’s contents. These are separate from ordinary values, so a search set to formulas or values may not find annotation text.

Use exact matching, case, and wildcards

Open Options in the Find dialog to see more matching controls. Two useful checkboxes are Match case and Match entire cell contents. Match case distinguishes uppercase and lowercase letters. Match entire cell contents requires the cell’s complete content to equal the search term, rather than merely containing it.

For instance, with exact-cell matching turned off, searching for East can match East Office or Northeast. Turn on Match entire cell contents to find a cell whose full content is just East. This is especially useful when a short term also appears inside longer labels, product codes, or names.

Find also supports wildcard characters for pattern searches:

Asterisk (*): represents any number of characters. Searching for ship* can match shipping, shipped, or shipment when those strings begin with ship.
Question mark (?): represents one character. Searching for c?t can match cat or cut, but not cart.
Tilde (~): treats a wildcard as a literal character. Search for ~* to find an actual asterisk, or ~? to find a question mark.

Wildcards are useful for inconsistent labels, but can also produce unexpected matches. If you want to find a literal asterisk in a code or note, do not enter * by itself: Excel will treat it as a pattern. Add the tilde first, then review the matches to confirm they are the cells you intended.

Find Next, Find All, and replacing text

Find Next is best when you want to inspect matches in sequence. Find All is more efficient when you need to see how widespread a term is, jump to a particular occurrence, or review results across a workbook. A result list can also help you distinguish repeated entries on different sheets without manually opening each tab.

Find is different from Replace. To change matching content, use Ctrl+H on Windows to open the Replace tab, or select Home > Find & Select > Replace. Enter the existing content in Find what and the new content in Replace with. Use Replace to handle matches individually, or Replace All to change every match in the chosen scope.

Be cautious with Replace All, particularly when the search term is short or when the scope is Workbook. A search for a common fragment could alter more cells than intended. A safer process is to use Find All first, verify the scope and matching cells, and then replace only if the results are appropriate. If the workbook is important, save a copy before making a large batch of changes.

Common reasons a search misses a match

If Ctrl+F appears not to find something visible, check the search settings before assuming the content is absent. Excel may be searching the wrong worksheet, looking in formulas instead of displayed values, requiring a whole-cell match, or using a case-sensitive search. A previous search can leave options changed, so reopen Options and inspect them when results seem surprising.

Other practical checks include:

Confirm the spelling, spaces, punctuation, and number format of the search term. A cell may contain a nonbreaking space or a slightly different label.
Check whether the intended content is a calculated result or part of a formula, then choose the corresponding Look in setting.
Change Within from Sheet to Workbook if you may be on the wrong tab.
Remove Match entire cell contents if the term should be found inside a longer cell entry.
Use Find All to see where Excel is finding matches, rather than relying on a single jump.

Numbers can also be confusing because a displayed number may be formatted differently from its stored value. For example, a cell might show a date in a readable format while its underlying value is a serial number. Search for what the cell displays with Look in set to Values, and consider the cell’s number format if the expected text still does not appear.

Windows, Mac, and Excel for the web

The main desktop shortcuts are Ctrl+F in Excel for Windows and Command+F in Excel for Mac. The Windows ribbon route is Home > Find & Select > Find; on a Mac, Command+F is the direct way to open Find, and ribbon or menu labels can vary slightly by release. Use the Find controls that appear in your installed version to set the search scope and matching options.

In Excel for the web, Ctrl+F opens Excel’s Find pane in a supported browser. The pane is designed for finding content in the workbook, though its layout and available controls are not identical to the full desktop dialog. Browser and operating-system key handling can affect shortcuts, so if Ctrl+F opens the browser’s own search instead, use Excel’s ribbon Find command. The Replace workflow and advanced options may also differ from desktop Excel.

Frequently Asked Questions

What is the shortcut for Find in Excel?
Press Ctrl+F in Excel for Windows. On a Mac, press Command+F. In Excel for the web, Ctrl+F usually opens the Find pane; use the ribbon command if the browser intercepts the shortcut.

How do I find a word in all Excel sheets?
Open Find with Ctrl+F, expand Options, and change Within from Sheet to Workbook. Use Find All to review the matching cells and their sheet locations.

Can Excel find text inside a formula?
Yes. In Find options, set Look in to Formulas to search formula text. Choose Values to search the calculated results displayed in cells.

Why does Ctrl+F find only some of my matches?
Check whether Within is set to Sheet instead of Workbook, whether Match entire cell contents or Match case is enabled, and whether Look in is set to the right content type. Wildcards can also affect what counts as a match.

How do I replace what I found?
Press Ctrl+H on Windows, or open Home > Find & Select > Replace. Use Replace to review changes one at a time or Replace All to change every match in the selected scope.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.