How to search all sheets in an Excel workbook
To search all worksheets in an Excel workbook for Windows, press Ctrl+F, open Options, and set Within to Workbook. Choose Find All to see matching cells together and jump directly to any result. The scope is the active workbook, even when you have other Excel files open.
Search the whole workbook
- Activate the file you want to search. Press Ctrl+F to open the Find tab in Find and Replace, enter the text or item code in Find what, and expand Options.
- Set Within to Workbook. In Look in, select Values to search for a result displayed in a cell, or Formulas to search the formula itself, such as a function name or cell reference.
- Choose Find All. Use the worksheet name and cell address to identify the right result, then click that row to jump to the cell. Choose Find Next if you prefer to visit matches one at a time.
Microsoft Support options for finding and replacing in Excel
Find an item on two monthly sheets
In a blank workbook, add two sheets named Jan and Feb. Type SKU-104 in Jan!B2 and Feb!D5, and type SKU-1040 in B3 on Jan. The text before the exclamation mark is the worksheet name.
Set Within to Workbook and Look in to Values, clear any search format, and turn on Match entire cell contents. Search for SKU-104 and click Find All. You should see two matches. Click the Feb result to select D5. Turn off the exact-match option and repeat the search to include SKU-1040, which contains the search text.
Fix missing or unexpected results
If you see results from just one sheet, check the search scope first. Switch to Values if you want a displayed formula result. An old search format can also hide matches: open the menu next to Format and choose Clear Find Format. Turn off Match case when capitalization should not matter. Turn off Match entire cell contents if you know only part of the text.
An asterisk (*) matches any sequence of characters, and a question mark (?) matches one character. Search for SKU-* to find codes with that prefix. To find a literal asterisk, use ~*. Search for ~? for an actual question mark or ~~ for an actual tilde.
Microsoft Support guide to search wildcards
Review matches before replacing
Save a copy of the file first. Use Ctrl+F and Find All to review the worksheets and matches. Then press Ctrl+H and check the scope and matching options on the Replace tab. Use Match entire cell contents when an item code must be replaced as a whole, so a longer code with the same prefix is excluded. The Replace tab searches formula text rather than displayed formula results. For a calculated value, inspect the formula or its source data before editing.
For a small set, find each match and choose Replace after checking the cell. Use Replace All only if the same change belongs in every match. Compare the replacement count with the list you reviewed and spot-check the updated sheets before saving.




