Excel Find and Replace: Search, Edit, and Fix Data

Excel’s Find and Replace feature searches a worksheet or workbook for text, numbers, or other cell content and can change matching entries in one step. In Excel for Microsoft 365 on Windows, press Ctrl+H, enter the text in “Find what” and “Replace with,” then choose Replace to review matches individually or Replace All to change every match in scope.

Where to find the feature

Find and Replace is useful for correcting repeated typos, updating a product label, changing a code, or locating a value in a large workbook. It changes cell contents; it is not a general-purpose way to rearrange data or apply a formula to a range.

On Windows, open it with Ctrl+H, or select Home > Find & Select > Replace. The Find tab in the same dialog searches without changing content; Ctrl+F opens that tab. On Mac, use Home > Find > Replace or the Edit menu’s Find commands; keyboard shortcuts can differ by keyboard and Excel version. In Excel for the web, use Home > Find & Select > Replace when available. Browser shortcuts may be intercepted by the browser, so the ribbon is the dependable route.

How to replace content step by step

For a controlled change, work through the dialog rather than immediately replacing everything. A practical sequence is:

Decide whether to search the current sheet or the whole workbook. If only part of a sheet should be changed, select that range first.
Open Replace and type the exact item to locate in “Find what.” Enter its replacement in “Replace with.” Leave the replacement field blank only if you intend to remove the matched text.
Open Options if needed. Choose the search scope and matching rules before starting.
Select Find Next to move through matches, then Replace to change one match at a time. Use Find All to list the matches before deciding what to do.
Choose Replace All only when the scope and matching options are correct. Excel reports how many replacements it made.

For example, if a worksheet contains the outdated department name “Customer Care” and it should now read “Client Support,” enter the former in “Find what” and the latter in “Replace with.” If the workbook has separate sheets with historical records, searching only the active sheet may be safer than replacing throughout the workbook. Confirm the results in context, since the same phrase may have a different meaning elsewhere.

Search scope and matching options

The options determine what Excel considers a match. “Within” lets you choose between the current sheet and the workbook. “Search” sets the direction through cells—by rows or by columns—and is mainly relevant when stepping through results. Search order does not usually matter for Replace All, but scope does.

“Match case” distinguishes uppercase and lowercase letters. “Match entire cell contents” requires the whole cell to equal the search text rather than merely containing it. For instance, searching for “East” without the whole-cell option can match “East Region”; with the option, it matches a cell whose complete content is “East.”

Excel can search in different kinds of cell content, such as formulas, values, or notes, depending on the dialog and version. Look in “Formulas” is often the right choice when searching the displayed text or formula text in cells; “Values” searches calculated results. Notes are older cell annotations, distinct from threaded comments. If a search seems to miss an item, check the Look in setting as well as the scope.

A selection can also affect the search area: when a range is selected, Excel may search within that selection rather than every cell on the sheet. If you expected a workbook-wide result, click a single cell or clear the selection, then explicitly choose Workbook under Within. This avoids both missed matches and unintended edits.

Wildcards and special characters

Find and Replace supports two wildcard characters for pattern matching. An asterisk (*) represents any sequence of characters, including no characters; a question mark (?) represents one character. These are useful for locating groups of entries, but they can also match more than intended.

Searching for Cat* can find entries that begin with “Cat,” such as “Catalog” or “Category.”
Searching for 202? can match four-character entries beginning with 202, such as “2023” or “2024.”
To search for a literal asterisk, question mark, or tilde, place a tilde (~) before it. For example, ~* searches for an actual asterisk rather than using the wildcard.

Wildcards are not regular expressions. They do not provide the full pattern-matching features available in programming languages or some text editors. If you use a wildcard with Replace All, inspect the scope and use Find All first when the possible matches are not obvious.

What Find and Replace changes—and what it does not

Replace changes matching content inside cells; it does not automatically change formatting, restructure a table, or update every related item in a workbook. If you need to change formatting, open the dialog’s Format options and specify the formatting to find or apply, where supported. For a straightforward text correction, leave formatting criteria unset.

Be careful when searching formulas. A formula contains text as well as references and operators. Replacing a fragment while looking in formulas can alter the formula itself, not merely the displayed result. For example, replacing a text fragment used inside a formula can change what the formula returns; replacing part of a function name or reference can break it. If the goal is to change calculated results, first determine whether you should edit source cells, formulas, or the underlying data.

Find and Replace also does not treat every visual similarity as a match. A number stored as text may behave differently from a numeric value, and two strings that look identical can contain different spaces or characters. If a search fails, inspect the cell’s formula bar, data type, and spacing. For leading or trailing spaces, a targeted cleanup method may be more appropriate than replacing a visible phrase.

Replace All safely

Replace All is efficient for a consistent, well-defined change, but it is easy to use too broadly. Before applying it, confirm that the search text is distinctive, the selected scope is right, and whole-cell or case matching is set as intended. A short search term such as “in” can occur inside many unrelated words; a broad wildcard can match still more.

Use Find All to review locations before making a large change.
Save a copy of an important workbook before a workbook-wide replacement.
Prefer individual Replace actions when matches need human judgment.
After replacement, check representative cells, formulas, totals, and any sheets that rely on the changed content.

Excel normally lets you undo a recent replacement with Ctrl+Z on Windows (Command+Z on Mac). Undo is not a substitute for a backup: later actions, closing the file, or other workflow details can limit what is available in the undo history. For high-impact edits, save a separate copy first and verify the outcome before continuing.

Find and Replace compared with other approaches

Use Find when you only need to locate or inspect content; it does not modify cells. Use Replace when you are correcting or standardizing a known string. If a value must be transformed according to a rule—for example, extracting part of each entry, combining columns, or cleaning inconsistent spaces—a formula or data-cleaning workflow may be more suitable than a one-time text substitution.

For recurring imports and repeatable transformations, Power Query can provide steps that are reapplied when data is refreshed. For a one-off correction across a modest range, Replace is usually quicker. If a change depends on conditions, such as replacing a label only when another column has a particular status, a formula or a carefully designed data operation is safer because Find and Replace does not evaluate those conditions.

There is no separate charge for Find and Replace beyond access to Excel; it is a built-in editing feature. Availability and exact interface details can vary between desktop Excel and the web app, so use the ribbon path in your version if a keyboard shortcut behaves differently.

Common problems and fixes

No results appear: Check whether Within is set to Sheet or Workbook, whether a range is selected, and whether Look in is set to Formulas, Values, or Notes as appropriate. Also check spelling, spaces, and case matching.
Too many results change: Undo immediately if possible, then narrow the scope or enable Match entire cell contents. Search a more distinctive phrase instead of a short fragment.
Only part of the intended text changes: Confirm that the replacement text is correct and that wildcards are not being interpreted as patterns. Use a literal-character escape with tilde when searching for wildcard symbols.
Displayed numbers are not found: The cell may contain a number while the displayed value is produced by number formatting, or the number may be stored as text. Try the appropriate Look in setting and inspect the actual cell content.
A formula behaves differently afterward: Review the formula bar and undo the edit if it changed a formula unintentionally. Search values when you mean to locate calculated results, and avoid replacing formula fragments unless you intend to edit formulas.

Frequently Asked Questions

What is the shortcut for Find and Replace in Excel?
In Excel for Microsoft 365 on Windows, Ctrl+H opens the Replace tab. Ctrl+F opens Find. On Mac or in a browser, shortcuts can vary or conflict with system commands, so use the Home ribbon’s Find commands if needed.

Can I replace text in every worksheet at once?
Yes. In the Find and Replace dialog, set “Within” to Workbook rather than Sheet. Review matches with Find All first if sheets contain different kinds of data or historical records.

Can Excel replace part of a cell instead of the whole cell?
Yes. By default, a search can match text within a longer cell entry. Enable “Match entire cell contents” only when the complete cell must equal the search term.

Can Find and Replace search formulas?
Yes, the Look in option can search formula content. Be cautious: a replacement may modify the formula itself. If you are trying to locate a calculated result, search values instead where that option is available.

How do I search for an asterisk or question mark literally?
Put a tilde before the character in “Find what”: use ~* for a literal asterisk and ~? for a literal question mark. Without the tilde, those characters act as wildcards.

Can I undo Replace All?
Usually, Ctrl+Z on Windows or Command+Z on Mac reverses a recent replacement. For a large or important edit, save a copy first and verify the change before doing more work.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.