Search Excel Shortcut Keys: Find Cells, Values, and Formulas

In Excel for Microsoft 365 on Windows, press Ctrl+F, enter the word, number, or phrase you want, then choose Find Next or Find All. Excel searches the current worksheet by default; use the Find options to search the entire workbook, look for displayed values instead of formulas, or narrow the match.

The shortcut for searching in Excel

Ctrl+F is the main keyboard shortcut for finding content in an Excel worksheet. It opens the Find interface, where you can type a search term and move through matching cells. For instance, if a sales sheet contains a customer named Rivera, press Ctrl+F, type Rivera, and select Find Next to jump to a matching cell. Press Find Next again to move to another match.

Use Find All when you want to see every matching cell at once rather than stepping through them individually. Excel displays a results list in the Find interface; selecting an entry takes you to that cell. This is useful when a term appears many times or when you need to compare matches before editing anything.

You can also open the command from the ribbon: Home > Find & Select > Find. The ribbon route is useful when you forget the shortcut, are using a device without a familiar keyboard, or want to confirm that you are opening Excel’s search rather than another application’s search.

How Find works

Excel’s Find command searches cell contents, not just the text currently visible on screen. The default search is limited to the active worksheet, and Find Next moves through matches in the order specified in the Find options. When it reaches the end of the search area, it can continue from the beginning, so a match may appear again if you keep advancing.

By default, a search can match part of a cell’s contents. Searching for lake may match a cell containing Lakeside. To restrict the result to cells whose entire contents equal your search term, open Options and select Match entire cell contents. You can also select Match case if capitalization matters. Without that setting, Excel generally treats uppercase and lowercase letters as equivalent.

Finding a match selects its cell; it does not change the cell’s contents. Close the Find interface when you are ready to work with the selected cell. If you want to make an edit across many matches, use Replace carefully instead of manually changing each selection.

Search one sheet or the whole workbook

To change where Excel searches, press Ctrl+F and choose Options in the Find interface. The Within setting lets you choose Sheet or Workbook. Sheet is the usual default. Workbook searches across the worksheets in the current workbook, which is helpful when a value might be on a different tab or when a large file has many related sheets.

The Options area also includes Search settings for searching by rows or by columns. These settings affect the order in which Excel visits cells; they do not change what counts as a match. Choose the direction that makes it easier to review results in your layout. You can also set a search range by selecting a group of cells before opening Find. If results seem unexpectedly limited, click a single cell and check that Within is set to the intended scope.

Before searching a large workbook, decide whether you need all worksheets or only the current one. A workbook-wide search may return repeated labels from headings, lookup tables, and archived sheets as well as the active data. Find All helps reveal where matches occur, but it is still worth checking the worksheet name and nearby cells before acting on a result.

Search formulas, displayed values, or formats

One common source of confusion is the difference between a formula and the value it displays. For example, a cell may show 250 while its formula bar contains a calculation. In Find Options, the Look in setting determines whether Excel searches formulas, values, or notes. The default is commonly Formulas, so a search for a displayed result may not behave as expected if the cell’s underlying formula is different.

If you want to find what appears in the grid, change Look in to Values. If you need to locate a particular formula or a reference written inside formulas, choose Formulas. For example, a search for a sheet name may find a reference in a formula even though that name is not visible as the cell’s displayed result. Choose Notes when you need to look for text in cell notes. These choices are about what Excel searches, not about changing the underlying data.

Find can also search for formatting. Open Options, use the Format control, and specify the format to look for; you can select a format from a cell rather than defining each property yourself. This is handy when you need to locate cells with a particular fill or number format. Clear the chosen format criteria when you no longer need them, or later searches may continue to use those criteria and appear to miss ordinary text matches.

Use partial matches and wildcard characters

When you do not know the full contents of a cell, Excel’s wildcard characters can broaden a search. An asterisk (*) stands for any number of characters, including none. A question mark (?) stands for one character. These are especially useful for finding groups of similarly named items or identifiers with a predictable pattern.

Search for North* to find entries that begin with North, such as North Office or North-02.
Search for *road to find entries ending in road, such as Oak Road.
Search for INV-??? to find identifiers beginning INV- followed by exactly three characters.
Use a tilde before a wildcard when you mean the character itself: ~* searches for a literal asterisk.

Wildcards are not the same as regular expressions, and they do not describe every possible pattern. If your search term includes * or ?, Excel may interpret it as a wildcard unless you escape it with a tilde. Also check for extra spaces: a cell containing a trailing space can look identical to one without it but may not match an exact whole-cell search in the way you expect.

Find versus Replace and other ways to locate data

Ctrl+F finds content without changing it. Ctrl+H opens the Replace interface, where you can search for one value and substitute another. Use Find Next to review individual matches before replacing them, or use Replace All only when you are confident the search scope and options are correct. A workbook-wide Replace All can alter cells on several sheets, so verify the Within setting and consider saving a separate copy before a broad change.

If you already know a cell address, Go To is faster than searching for its contents. Press Ctrl+G or F5 on Windows to open Go To, then enter an address such as D250. You can also use the Name Box to the left of the formula bar: type a cell address and press Enter. These methods navigate by location, whereas Ctrl+F searches cell content.

When you want to narrow a list by a column’s values rather than jump between individual matches, use filters. Select a cell in the data and choose Data > Filter, then use the column’s filter menu to show only relevant entries. Filtering is better for reviewing a set of records; Find is usually quicker for locating a particular phrase or isolated cell.

Common search problems and fixes

The visible result is not found: In Options, change Look in from Formulas to Values. This matters when a formula calculates the value you see.
Excel finds only some matches: Check Match case, Match entire cell contents, the search scope, and any selected range. Turn off restrictions that do not apply.
The search returns too many results: Use a more distinctive term, select Match entire cell contents, or limit Within to Sheet.
A wildcard is treated as a pattern: Put a tilde before a literal asterisk or question mark, such as ~?.
A format search misses cells: Clear the Format criteria and try again, or use Find Format to confirm which formatting attributes are selected.

Also consider whether the data is actually stored as text or as a number. A value that looks like 00123 may be stored as text in one cell and as the number 123 in another with a custom display format. Searching for the displayed characters may therefore give different results depending on Look in and the cell’s stored content. If you are unsure, inspect a matched cell in the formula bar and check its number format.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, Command+F is the usual Find shortcut; Command+H opens Replace. The names and arrangement of controls can differ slightly from Windows, but the core choices—search scope, match case, whole-cell matching, and what to look in—serve the same purpose. If a shortcut conflicts with a system or keyboard setting, use Excel’s ribbon Find command instead.

Excel for the web also provides a Find command, but the search interface and keyboard behavior can vary with the browser and the current app experience. If Ctrl+F does not open Excel’s search as expected, use the Find command on the Home tab. The desktop instructions above refer to Excel for Microsoft 365 on Windows; do not assume every dialog or option is positioned identically in the web version.

Frequently Asked Questions

What is the shortcut key to search in Excel?
On Windows, press Ctrl+F to open Find. On Mac, use Command+F. Enter a search term and select Find Next or Find All.

How do I search all sheets in an Excel workbook?
Open Find with Ctrl+F, select Options, and change Within from Sheet to Workbook. Then search for the term; Find All can show the matching cells across the workbook.

How do I find a word in Excel without matching part of another word?
Open Find Options and select Match entire cell contents. This restricts matches to cells whose complete contents are the search term, rather than cells that merely contain it.

Why does Ctrl+F not find the number shown in a cell?
The cell may display a calculated result while containing a formula. In Find Options, change Look in to Values to search the displayed result rather than the formula text.

Can I search for part of a word in Excel?
Yes. Partial matching is available by default. You can also use * for any number of characters and ? for one character when a more flexible pattern is useful.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.