Excel Find and Replace: How It Works and When to Use It

Yes. Excel for Microsoft 365 on Windows has a Find and Replace function: press Ctrl+H, or choose Home > Find & Select > Replace. It can locate text or numbers and replace matches in a worksheet or across a workbook, with options to narrow what Excel searches.

How to open Find and Replace

In the Windows desktop app, Ctrl+H opens the Replace tab of the Find and Replace dialog. You can also open it from the Home tab using Find & Select > Replace. To search without changing anything, press Ctrl+F or choose Home > Find & Select > Find. The dialog lets you switch between its Find and Replace tabs.

Enter the text or number to locate in Find what, then enter the new content in Replace with. Use Find Next to review matches one at a time, Replace to change the current match, or Replace All to update every match in the selected search scope. Excel reports how many replacements it made after Replace All.

For example, to change the word North to South in a set of labels, enter North in Find what and South in Replace with. Review a match first if you are unsure where it appears. Find and Replace changes cell contents; it is not merely a visual highlighting tool.

What Excel can find and replace

The feature can search for text and numbers in cell contents, including text that appears inside a longer entry. If a cell contains North District, searching for North can locate that part of the entry. Replacing it with South changes the cell to South District. A search for a number can also match digits within a longer value, so check whether a search such as 25 might catch entries beyond the one you intended.

Excel also provides a Look in option in the dialog. Depending on the Excel version and context, it can let you search formulas, displayed values, or notes. This distinction matters in a cell containing a formula: searching formulas can find text in the formula itself, while searching values concerns what the formula calculates and displays. If you intend to edit formulas, use the formula search setting and inspect the results carefully.

Find and Replace can also search for formatting in versions that show the Format controls in the dialog. That can help locate cells with a particular number format or other formatting, but it is separate from searching for a word. The feature does not automatically understand the meaning of your data: it matches content according to the search options you set.

Choose the search scope before replacing

By default, a search may be limited to the active worksheet. The dialog’s Within setting can offer Sheet or Workbook, allowing you to search just the current sheet or across worksheets in the file. Workbook-wide replacement is useful when a label has changed everywhere, but it increases the chance of altering unrelated content.

If you select a range before opening Find and Replace, Excel can limit the search to that selection. This is a practical way to protect other parts of a sheet—for example, selecting the customer-name column before correcting an old company name. Confirm the selected cells and the Within setting before using Replace All, especially if the workbook contains many sheets.

The Search setting can also determine whether Excel scans by rows or by columns. That option usually does not affect which matches exist, but it can change the order in which Find Next visits them. If you only need to confirm whether something appears, use Find All when available to see a list of matches rather than stepping through them individually.

Use exact matching and wildcards carefully

Search options help distinguish a precise match from a partial one. Match case makes uppercase and lowercase letters matter, so North and north are treated differently. Match entire cell contents restricts results to cells whose entire content matches the search term; without it, a search can find the term inside longer text.

Excel supports wildcard characters in the Find what field. An asterisk (*) represents any number of characters, while a question mark (?) represents one character. For instance, searching for Jo*n can locate text such as Joan or John. To search for a literal asterisk, question mark, or tilde, put a tilde (~) before that character. Wildcards are useful for finding patterns, but Replace All with a wildcard can affect more cells than a literal search would.

Use wildcards only when the pattern is genuinely consistent. If you search for A* intending to find entries that begin with A, inspect the matches: the wildcard can match varying text, and the rest of the cell may determine which entries qualify. For a one-time cleanup, Find Next and Replace are safer than assuming a pattern will isolate the right records.

Practical examples

Find and Replace is especially useful for repetitive corrections and standardization. Some common tasks include:

Correcting a misspelled product name that appears in many cells.
Changing a department label across several worksheets after a reorganization.
Replacing an old web address with a new one in a list of links or text entries.
Removing a repeated text prefix by replacing it with nothing, after checking that the prefix is not needed elsewhere.
Finding a fragment in formulas when a referenced sheet or named item has changed.

For example, replacing the text 2023 with 2024 may be appropriate in a column of year labels, but it can also change product codes, notes, or formulas containing those digits. Select the intended range first, or use Find Next to review matches. Dates can be especially confusing: Excel stores dates as serial numbers and displays them according to cell formatting, so searching for a displayed date may not behave like searching for ordinary text.

Replace one match or use Replace All?

Replace is the controlled choice when the match could have different meanings in different places. It changes the current result and lets you review the next one. This is helpful for names, abbreviations, or short number strings that might appear in unrelated data. Use Find Next to skip a match that should stay as it is.

Replace All is faster when every occurrence within the chosen scope should change—for example, a typo in a dedicated list of product names. Before using it, check the search term, replacement text, worksheet or workbook scope, and any options such as Match case or Match entire cell contents. A replacement that deletes text can leave cells blank or alter formulas, so a backup copy is sensible for high-impact edits.

If you notice an unintended change immediately, Ctrl+Z is Excel’s usual undo shortcut on Windows. On Mac, use Command+Z. Do not treat undo as a substitute for checking the scope first, particularly when making a broad workbook-wide change or editing important formulas.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. In Excel for Mac, Find and Replace is also available from the Home tab’s Find & Select menu; Control+H is the common shortcut for opening Replace, while Command+F opens Find. Mac keyboard settings and app versions can affect shortcuts, so use the ribbon menu if a shortcut does not open the expected dialog.

Excel for the web also includes find-and-replace tools through the Home tab’s Find & Select menu, although the interface and available options can differ from the desktop app. Browser keyboard shortcuts may take precedence, so the ribbon is a reliable way to locate the command. If a workbook-wide operation or a particular advanced search option is missing, opening the file in the desktop app may provide more controls.

Common problems and how to avoid them

If Excel reports no matches, check for extra spaces, spelling differences, the selected range, and whether the search is restricted to the current sheet. Also review Match case and Match entire cell contents: either option can exclude results that a less restrictive search would find. If the workbook contains formulas, confirm whether Look in is set to formulas or values.

If Replace All changes too much, the search term may have been part of longer entries, or the scope may have included more sheets than intended. Undo immediately if appropriate, then repeat the operation on a selected range or use Find Next to review matches. If the replacement appears not to change a formula result, remember that a displayed value and the formula that produces it are different things; search the formula itself when that is what needs editing.

Another frequent misconception is that Find and Replace changes only what is visible on screen. It can affect cells outside the currently visible portion of a sheet if they are within the search scope. Hidden rows or columns and other worksheets are reasons to verify the scope and inspect the replacement count rather than assuming Excel only edited the visible cells.

When a formula or another tool is better

Find and Replace is an in-place editing tool: it changes existing cell contents. For a repeatable transformation that should update when the source changes, a formula can be better. With the original text in A2, this formula returns a version with North changed to South:

=SUBSTITUTE(A2,"North","South")

If A2 contains North District, the formula returns South District, while A2 remains unchanged. This is useful when you want to preserve the source data or compare old and transformed entries. The result is a formula output, not an automatic replacement of the original cell; copy and paste values only if you deliberately want fixed results. For splitting or reorganizing data, tools such as Text to Columns or Flash Fill may fit better than replacing text across cells.

Frequently Asked Questions

Does Excel have a shortcut for Find and Replace?
Yes. In Excel for Microsoft 365 on Windows, Ctrl+H opens Find and Replace. On Mac, Control+H commonly opens Replace; use Home > Find & Select if the shortcut behaves differently.

Can I replace text in every worksheet at once?
Yes. In the Find and Replace dialog, set Within to Workbook if that option is available, then use Replace or Replace All. Review the matches and scope first so that similarly worded content on unrelated sheets is not changed by mistake.

Can Excel find part of a cell’s text?
Yes. Unless Match entire cell contents is selected, Excel can find a search term that appears within longer cell content. For example, searching for East can match East Office. Use the exact-match option when you only want cells containing that complete entry.

Can Find and Replace change formulas?
It can search formula text when the dialog’s Look in setting is set to Formulas, and replacement can alter the formula itself. Because a small text change can break a calculation or reference, inspect matches and keep a backup before making broad formula edits.

Can I replace a word with nothing?
Yes. Enter the word in Find what and leave Replace with blank, then choose Replace or Replace All. Check the scope first: deleting a repeated fragment can remove meaningful text from many cells at once.

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.