Excel Find and Replace: Steps, Options, and Common Fixes

To find or replace content in Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace, enter the text in Find what and Replace with, then choose Replace or Replace All. Use Ctrl+F when you only need to locate something, and check the search options before replacing many cells at once.

How Find and Replace works

Excel searches cell contents, and it can also search formula text or other workbook elements depending on the options selected. Find is useful for locating an entry without changing it; Replace makes a targeted edit, while Replace All changes every match in the chosen search scope. The feature can update words, numbers, parts of formulas, and—in supported cases—cell formatting.

Find and Replace does not work like a word processor’s general document-wide search in every respect. A worksheet is a grid of cells, formulas may produce displayed results that differ from the formula text, and a search can be limited to a selection, a sheet, or a workbook. Those distinctions matter when the same term appears in several places or when a change could affect calculations.

Find or replace text step by step

Open the workbook and, if appropriate, select the cells you want to search. Selecting a range can help keep the operation focused; otherwise, check the search scope in the dialog.
Press Ctrl+F to find, or Ctrl+H to open the Replace tab of Find and Replace.
Type the target in Find what. If replacing, type the new content in Replace with. Leave Replace with blank when the goal is to remove the matching text.
Choose Find Next to inspect matches one at a time, or Find All to list them. For a replacement you have checked, use Replace for the current match or Replace All for all matches in scope.
Review Excel’s confirmation message, which reports how many replacements were made. Check representative cells and save the workbook when the result is correct.

For example, suppose a product list contains “Northwind – Blue” and “Northwind – Green,” and you need to rename the supplier. Find Northwind and replace it with Contoso. Replacing the full name preserves each color suffix. Searching for the whole phrase instead would only change one exact product entry.

Choose the right search scope and options

In the Find and Replace dialog, select Options to reveal controls that determine what Excel searches. Their labels and available choices can vary slightly by Excel build, but the key settings help avoid surprising matches:

Within: Choose Sheet to search the active worksheet or Workbook to search across worksheets. Workbook scope is useful for a global rename, but it can reach hidden sheets too.
Search: Choose whether Excel searches by rows or columns. This affects the order in which matches are visited; it does not change which cells qualify.
Look in: Choose Formulas to search formula text, or Values to search displayed results. Depending on the version, other options such as notes or comments may appear.
Match case: Turn this on when uppercase and lowercase letters must be treated as different.
Match entire cell contents: Turn this on to find cells whose complete contents match the search term, rather than cells that merely contain it as part of a longer entry.

For instance, searching for “cat” without matching entire cell contents could also find “catalog.” Enabling the whole-cell option limits the match to a cell containing only “cat.” If the active cell is inside a selected range, make sure the intended selection and scope are clear before running Replace All.

Search with wildcards

Excel’s Find and Replace supports wildcard characters for pattern matching. An asterisk (*) represents any number of characters, including none; a question mark (?) represents one character. For example, searching for sm?th can match “smith” or “smyth,” while pre* can match entries beginning with “pre.” These wildcards can make a broad search efficient, but they can also match more cells than a literal search.

To search for a literal asterisk, question mark, or tilde, place a tilde (~) before it. For example, use ~* to find an actual asterisk in a cell, rather than treating the asterisk as a wildcard. Excel’s standard Find and Replace is not a regular-expression search, so regular-expression patterns should not be expected to work.

Try a wildcard search with Find All first and review the returned cells. If you use it with Replace All, a pattern such as INV-* may select every entry beginning with “INV-,” even if the suffixes differ. A quick review is especially important when the pattern could match codes, identifiers, or text used by formulas.

Replace numbers, dates, and formula text carefully

Numbers and dates can be less straightforward than words because Excel stores dates as numeric serial values and displays them using cell formatting. A date that appears as “03/04/2026” may be interpreted differently by people using different regional date conventions. Before replacing date-like content, confirm the cells’ actual values and the workbook’s intended date format; do not assume the displayed string is stored exactly as typed.

Formula searches need similar care. With Look in: Formulas, a search can find text inside a formula, even when that text is not visible in the cell’s result. Replacing part of a formula can change its references, criteria, or text output. For example, a workbook-wide replacement of a short word might alter a text criterion embedded in multiple formulas. Use Find Next or Find All to inspect affected formulas before changing them.

When the aim is to change a displayed result rather than the formula that produces it, search values and confirm that the intended cells are included. Conversely, if you need to revise a repeated phrase inside formulas, search formulas and make a small, reviewed change. Avoid using Replace All on formulas simply because the visible worksheet appears to contain the target word.

Replace formatting as well as content

Find and Replace can also locate cells by formatting, which is useful when a workbook contains inconsistent styling. Open the dialog and use the Format controls beside the Find and Replace fields to specify formatting to find, formatting to apply, or both. The exact controls can depend on the Excel version. You can use format criteria without entering text, but make sure the specified formatting is the intended target.

For example, if several cells use an old fill color, you can search for that format and replace it with a new one. A cell may combine multiple properties—such as font, fill, and number format—so a format search can be narrower or broader than expected depending on the criteria set. Clear unwanted format criteria before a later text search if matches seem unexpectedly limited. The dialog’s Find Format or Replace Format controls provide a way to reset or adjust these criteria.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. On Windows, Ctrl+F opens Find and Ctrl+H opens Find and Replace. In Excel for Mac, use the Edit menu’s find and replace commands; keyboard shortcuts can differ with the Mac keyboard layout and Excel version, so the menu is the dependable route if a shortcut does not open the right dialog.

Excel for the web has a different interface from the desktop app. Use the Home tab’s Find & Select menu and choose Replace when available. Browser shortcuts can conflict with Excel shortcuts—for example, Ctrl+H may open browser history—so use the ribbon command if the shortcut is intercepted. Some advanced dialog options or formatting controls may not be available in the web interface; open the workbook in the desktop app if you need a control that is missing.

Common problems and safer ways to fix them

Excel reports no matches: Check spelling, spaces, the active range, the selected sheet or workbook scope, and the Look in setting. A search for a displayed formula result may not find it if Excel is searching formula text.
Too many cells change: Undo immediately with Ctrl+Z on Windows, then repeat the operation with a narrower selection, sheet scope, or whole-cell matching. Undo is available for normal worksheet replacements, but it is not a substitute for checking before a broad change.
Only part of a word changes: Enable Match entire cell contents if you want to match a cell’s complete content. If you want to replace a phrase within longer text, leave that option off and inspect the matches first.
Replace All changes formulas: Check whether Look in is set to Formulas and inspect the affected formulas. Undo if the changes are unwanted, then use the correct search mode or a narrower scope.
A previous format search affects results: Clear the Find or Replace format criteria and try again. Formatting criteria can remain set in the dialog and constrain later searches.
The search wraps around: Excel may continue from the end of a sheet to the beginning. This is normal; review the search scope and the full match list rather than assuming a match was missed.

For high-impact edits, save a copy of the workbook before replacing content across many sheets. You can also use Find All to inspect results, then replace matches individually. This takes longer than Replace All, but it reduces the risk of changing an abbreviation, formula criterion, or identifier that happens to contain the same characters.

Frequently Asked Questions

How do I find a word in Excel without replacing it?
Press Ctrl+F on Windows, enter the word in Find what, and choose Find Next or Find All. On Mac or the web, use the app’s Find command if the Windows shortcut is unavailable.

Can I replace text in the whole workbook?
Yes. Open Find and Replace, show Options, and set Within to Workbook. Review the matches first, because this scope can include multiple worksheets and may include hidden sheets.

How do I remove a word from cells?
Put the word in Find what, leave Replace with empty, and choose Replace or Replace All. If the word appears inside longer entries, check the whole-cell option so you remove only the intended text.

Can Find and Replace change formulas?
Yes. Set Look in to Formulas to search formula text, and be cautious when replacing. A change to a formula’s text can alter its result or references, so inspect the matches before applying it broadly.

Can Excel find part of a word?
Yes. By default, Excel can find a search term inside longer cell contents. Turn on Match entire cell contents when you want the whole cell to equal the term, or use wildcards when you intentionally need a pattern.

Why does Ctrl+H open something else?
On Windows desktop Excel, Ctrl+H normally opens Find and Replace. In a browser, the shortcut may be captured by the browser, and Mac shortcuts differ. Use Excel’s Home or Edit menu command to open Replace directly.

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.