Excel Find and Replace: Values, Formulas, and Options

To find and replace values in Excel, press Ctrl+H on Windows, enter the text or value under Find what and its replacement under Replace with, then choose Replace or Replace All. Use Options to limit the search to a sheet or workbook, match case, or search formulas instead of displayed values; check the scope before replacing many cells.

How Find and Replace works

Excel’s Find and Replace tool searches cell contents and can change matching content in one cell at a time or across many cells. In Microsoft 365 for Windows, open it with Ctrl+H, or select Home > Find & Select > Replace. On Mac, Control+H opens Find and Replace; the menu path is Edit > Find > Replace. The dialog has separate Find and Replace tabs, and its Options area exposes settings that affect where and how Excel searches.

Type the target into Find what and the new content into Replace with. Choose Find Next to inspect matches in sequence, Replace to change the selected match and move on, or Replace All to change every match within the chosen scope. Replace All reports how many replacements it made. If you only need to locate an item without changing it, use Find Next or Find All instead.

For example, suppose a worksheet has a product category spelled as “Stationary” in several cells, but the correct label is “Stationery.” Enter the first spelling in Find what and the second in Replace with. If only that category should change, check the matches first or restrict the operation to the relevant column. A broad replacement can affect notes, labels, or other legitimate uses of the same text.

Choose the right search scope

By default, Find and Replace searches the active worksheet. In Options, set Within to Sheet or Workbook. Workbook scope can be useful when a repeated label appears on many tabs, but it also raises the risk of changing cells you did not mean to edit. Workbook searches include sheets in the current workbook, not other open workbooks.

A selection can also limit the search. If you select a range before opening the dialog, Excel generally searches within that selection. This is useful when a value should change only in one table column. If the dialog behaves as though it is searching too little, clear the selection by clicking a single cell and check the Within setting. A search started with a selected range should not be assumed to cover the entire sheet.

Use a selected range when the change belongs in a specific table or column.
Use Sheet when you intend to search the active worksheet beyond a small selection.
Use Workbook only after considering every worksheet that may contain the same text.
Use Find All first when you need to review the locations before making a broad change.

Search formulas or displayed values

Find and Replace can search different aspects of a cell. In Options, Look in commonly offers Formulas, Values, and, depending on the Excel version, Notes or Comments. Formulas searches the stored formula text. Values searches the value Excel displays after calculating a formula, while Notes or Comments searches those annotations. These choices matter because a cell’s visible result may not be the text stored in the cell.

Consider a cell containing a formula that displays 150. Searching in Values can find the displayed result, while searching in Formulas looks for text in the formula itself, such as a cell reference or a function name. Do not treat a displayed formula result as though it were a typed-in constant: replacing a match can alter cell contents, and a replacement that removes a formula can eliminate its calculation. If the goal is to change the underlying inputs, locate and edit those input cells rather than replacing a calculated result.

For a simple, typed-in label or identifier, searching formulas is often the expected setting because constants are represented directly in the cell contents. If a match is not found, inspect Look in and the cell itself. Also check whether the cell contains a formula, a number stored as text, or a formatted value such as a date. The visible appearance alone does not always reveal the stored content.

Use search options precisely

Options include controls for matching case and matching entire cell contents. Match case distinguishes capitalization, so a search for “west” will not be treated the same as “West” when that option is selected. Match entire cell contents prevents a short search term from matching a longer entry. For instance, searching for “cat” with this option selected will not match “catalog.” Without it, the term may match as part of a longer cell entry.

Excel can also search by formatting. Open the Find and Replace dialog’s Format controls to specify a format to find, and use the replacement-format controls if you intend to change formatting as well as content. A format search can be useful when cells look alike but contain different values, or when a previous operation applied a distinctive fill or number format. If a format criterion is active unexpectedly, clear it before a text search; otherwise, Excel may skip cells that do not meet the formatting condition.

Use the following checks when results seem incomplete or unexpectedly broad:

Confirm Look in is set to the type of content you want to search.
Check Within, Match case, and Match entire cell contents.
Clear any Find Format condition that should not apply.
Check whether a range is selected and whether hidden or filtered rows affect what you can see.
Try Find Next on a known example before using Replace All.

Use wildcards for variable text

In Find and Replace, the asterisk (*) can stand for any number of characters, and the question mark (?) can stand for one character. These wildcards help when entries share a pattern but not an identical spelling. For example, searching for “North*” can find cell contents that begin with North, subject to the other search settings. Searching for “Item?” can match a five-character entry starting with Item followed by one character.

To search for a literal asterisk, question mark, or tilde rather than use it as a wildcard, put a tilde (~) before it. For example, ~? searches for an actual question mark. Wildcards can make Replace All powerful but risky: a broad pattern may match more entries than its short search text suggests. Use Find All to review the results before replacing wildcard matches, especially in a workbook with mixed labels or codes.

Replace text, numbers, and dates carefully

Text replacements are usually straightforward, but numbers and dates may have different stored forms and displayed formats. A date displayed as 3/4/2026 may be stored as a serial number with a date format. Searching for the visible date may not behave like searching for ordinary text, particularly if Look in is set to Formulas or the cell has a custom format. When a date replacement matters, check the cell’s value and number format rather than relying only on how it looks.

Excel also distinguishes numbers from numbers stored as text. The entries 00127 and 127 may look related but can have different contents and meanings, especially when they are product codes or postal codes. Replacing text in a code column can remove leading zeros or change identifiers if the cells are converted or formatted differently. If the values are identifiers rather than quantities, preserve them as text and verify a few results after replacing.

For a safer change, work on a copy of the file or save a version before a large replacement. Then use Find All to review locations, choose Replace for a few controlled changes, and confirm the results before applying Replace All. Ctrl+Z can undo a replacement in the current session, but it is not a substitute for a backup, particularly if you make further edits or close the workbook.

Common problems and how to fix them

A frequent problem is that Excel reports no matches even though the text is visible. The search may be looking in formulas rather than values, may be restricted to a selection, or may have Match entire cell contents enabled. Extra spaces, punctuation, capitalization, and nonbreaking spaces copied from websites can also make two entries look identical while their contents differ. Try a smaller search term, review the options, and inspect a cell’s contents in the formula bar.

Another common surprise is changing more cells than intended. Replace All applies to every match in scope, not merely the match currently visible on screen. It can affect cells on other sheets if Within is set to Workbook, and it can change a substring inside a longer cell when entire-cell matching is off. Filtered or hidden rows deserve extra care: do not assume that a visible-only display automatically limits the operation to the rows you can see.

If Replace All changes nothing, check whether the replacement text is identical to the existing content, whether a format criterion is filtering results, and whether the search term is being interpreted as a wildcard. If formulas appear to have changed, use Undo immediately if it is available, then inspect the affected cells. For a complex or important workbook, test the operation on a duplicate sheet or a saved copy first.

When to use another method

Find and Replace is best for direct, one-time edits to matching cell contents. It is not always the best way to transform values according to a rule. If every occurrence of a word inside a longer text string must change as part of a repeatable calculation, a worksheet formula or a Power Query transformation may be easier to audit and refresh. Power Query is especially useful when the same cleanup must be repeated after importing updated data.

For a small, fixed number of entries, editing cells directly may be safer than a broad replacement. For changes based on conditions—such as changing a category only when a second column has a particular status—use a filtered review or a formula-driven approach rather than replacing a term everywhere. The useful distinction is whether the task is “change this exact text wherever it occurs” or “apply a rule to selected records.” Find and Replace handles the first; structured data tools are often clearer for the second.

Frequently Asked Questions

How do I replace all values in Excel?
Press Ctrl+H on Windows, enter the old and new content, check the search scope and options, then select Replace All. Use Find All first if you need to confirm which cells will be affected.

Can I replace a value in just one column?
Yes. Select the cells in that column, open Find and Replace, and search the selection. Confirm the intended range is selected before replacing, especially if the worksheet contains other columns with the same text.

Can Find and Replace change part of a cell’s text?
Yes. With Match entire cell contents turned off, a search term can match within longer cell contents. Use wildcards for patterns, and review matches before using Replace All.

Why does Excel find a value but not replace it as expected?
Check Look in, the search scope, matching options, and any format criterion. Also determine whether the visible value is a formula result, a formatted date, or a number stored as text; those are not always the same as the displayed characters.

Does Find and Replace work across every worksheet?
It can search the current workbook when Within is set to Workbook. Check that setting before using Replace All, since the same text may have a different purpose on another worksheet.

Can I undo Replace All?
Ctrl+Z on Windows, or Command+Z on Mac, usually undoes the most recent replacement while it remains in the undo history. Save a copy before a high-impact change rather than relying only on Undo.

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.