Excel Find and Replace: Search and Edit Cells

In Excel for Microsoft 365 on Windows, open Find and Replace with Ctrl+H, enter the text to look for and its replacement, then choose Replace or Replace All. Use Replace to review matches one at a time; use Replace All to change every match in the selected search scope.

Where to find the command

The Replace command is part of Excel’s Find & Select tools. You can open it from the keyboard or the ribbon:

Press Ctrl+H on Windows to open the Replace tab of the Find and Replace dialog box.
Or select Home > Find & Select > Replace.

To search without changing anything, press Ctrl+F or choose Home > Find & Select > Find. The Find and Replace dialog has separate Find and Replace tabs, so you can switch between searching and editing without closing it. Find and Replace is useful for text, numbers, and certain formatting attributes, but it is not a general-purpose tool for rewriting complex formulas or restructuring a worksheet.

How to replace text or values

For a straightforward change, first decide whether you want to check each match or update all matches at once. The basic process is:

Press Ctrl+H and enter the existing text or value in Find what.
Enter the new text or value in Replace with. Leave this box empty if you intend to remove the matched content.
Select Find Next to locate a match. Choose Replace to change that match and continue, or select Replace All to apply the change throughout the current scope.
Read Excel’s confirmation message, which reports how many replacements were made, and inspect the affected cells.

For example, if a list contains the label Pending and the correct label is In review, enter those exact strings in the two boxes. Replace All changes every match covered by the search options. If only some rows should change, use Find Next and Replace, or select the relevant cells before opening the command. A replacement is not limited to what is visible on screen: the scope and search settings determine which cells Excel considers.

Choose the search scope and options

Select Options in the dialog to expose controls that affect what Excel searches. The available choices can vary slightly with the Excel version, but important settings include the following:

Within: Choose Sheet to search the active worksheet or Workbook to search across worksheets in the current workbook. Workbook-wide replacement can affect sheets you are not currently viewing.
Search: Choose whether Excel searches by rows or by columns. This affects the order in which Find Next visits matches, not which cells match.
Look in: Choose what Excel examines, such as formulas, displayed values, or notes. If the expected result does not appear, check this setting before assuming the text is absent.
Match case: Turn this on when uppercase and lowercase letters must be distinguished.
Match entire cell contents: Turn this on to match a cell only when its whole content equals the search term, rather than when the term appears inside a longer entry.

A selected range can also limit the search. If you want to replace text only in a particular column or block, select that range first and check the dialog’s scope and results carefully. This is often safer than choosing Workbook and trying to undo an unexpectedly broad change. If a workbook contains multiple sheets, remember that the active sheet is not the same thing as the entire workbook.

Searching with wildcards

Excel’s Find and Replace supports wildcard characters for matching patterns in text. An asterisk (*) matches any number of characters, including none; a question mark (?) matches one character. These can help find entries that share a pattern but do not have identical wording.

Searching for north* can find entries such as North, northern, or north region, depending on the exact cell content and whether Match entire cell contents is enabled.
Searching for J?n can match three-character strings such as Jan or Jon.
To search for a literal asterisk, question mark, or tilde, put a tilde (~) before it. For instance, ~* searches for an actual asterisk rather than treating it as a wildcard.

Wildcards are powerful but can make Replace All broader than intended. A search such as * can match many text entries, so test a pattern with Find Next before replacing. Excel’s dialog is not a regular-expression engine: do not expect regular-expression syntax or capture-group features to work as they do in specialist text editors.

Searching formulas, displayed values, and formatting

A cell can show one thing while containing another. For example, a cell might display 25 but contain a formula that calculates 25. The Look in setting determines whether Find examines the formula itself or its calculated value. Searching formulas can be useful when tracking down references or a repeated fragment in formulas; searching values is more appropriate when you are looking for what appears in the worksheet.

Be cautious when replacing text in formulas. If the search is set to formulas, a replacement can modify formula text and may change how calculations work. For example, changing a repeated sheet name or function argument could affect many formulas at once. Save a copy before broad formula replacements, and verify representative formulas afterward. Find and Replace does not explain the meaning of a formula before changing it.

The dialog also provides formatting controls. Select the formatting controls beside the Find or Replace fields to specify formatting to search for or apply, such as a particular font or fill. This can help locate cells that share a format, or replace formatting without changing their contents. If a search behaves as though it has an invisible restriction, reopen the formatting controls and clear any criteria you no longer need. Formatting searches are distinct from searching the text or value inside a cell.

Practical examples and when to use Replace

Find and Replace is especially useful for consistent, literal edits across a worksheet. Common examples include correcting a misspelled department name, changing a repeated project label, removing an obsolete text prefix, or updating a common text value in imported data. It can also search for numbers, but be deliberate: the same number may have different meanings in different columns.

Suppose a sheet has a column of product descriptions and several cells include the phrase old model. Replacing that phrase with previous model is a focused text edit. If you instead search for the single digit 2 across the workbook, Excel may find it in dates, codes, amounts, and formulas. Restrict the search to the relevant range, use Match entire cell contents when appropriate, and inspect matches before making a global change.

Choose Replace rather than Replace All when the matches need judgment. It lets you review each result and skip exceptions. Choose Replace All when the target is unambiguous, the scope is correct, and changing every match is genuinely intended. For repeated clean-up of structured data, tools such as Flash Fill, formulas, or Power Query may be more suitable than a text replacement, depending on whether the transformation needs to be repeated or kept traceable.

Common problems and safe use

If Excel reports no matches, check the active sheet, selected range, Within setting, Look in setting, and any formatting criteria. Also check for Match case or Match entire cell contents, which can make a search more specific than expected. A cell may contain a formula rather than the visible result, or a value may be stored differently from how it is displayed. For example, a date is stored as a serial number even though the worksheet displays it in a date format.

Before a large replacement, consider saving a copy of the workbook. Excel normally lets you undo a replacement with Ctrl+Z, but undo is not a substitute for a backup when a change is consequential or you continue editing afterward. After replacement, check the confirmation count and inspect cells in different parts of the affected range. If formulas, labels, or identifiers were involved, verify that representative calculations and references still make sense.

Another common misunderstanding is that Find and Replace changes only what is currently visible. It can search cells beyond the current screen, and selecting Workbook can extend the operation to other sheets. Hidden rows or filtered-out records should not be treated as protection from a broad operation. Set the scope intentionally instead of relying on what happens to be visible.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. In Excel for Mac, use the Edit > Find > Replace menu path or the Home ribbon’s Find tools; keyboard shortcuts can differ with the Excel release, macOS settings, and keyboard layout. If a Windows shortcut does not open the dialog on a Mac, use the menu command rather than assuming the workbook lacks the feature.

Excel for the web also includes Find and Replace through its ribbon, though browser shortcuts may be handled by the browser instead of Excel. Use the ribbon’s Find & Select or Find tools if a shortcut opens a browser feature. Dialog layout and some options can differ from desktop Excel, so check the controls shown in the web version before relying on a setting such as search scope or formatting criteria.

Frequently Asked Questions

What is the shortcut for Find and Replace in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+H to open Replace. On a Mac, use Edit > Find > Replace if the keyboard shortcut differs or is unavailable.

How do I replace a word in only one column?
Select the cells in that column that you want to search, open Replace, and confirm that the search is limited to the selection or intended worksheet scope. Test with Find Next before choosing Replace All.

Can Excel Find and Replace change formulas?
Yes. If Look in is set to formulas, replacement can edit formula text. A broad change may alter calculation logic, so save a copy and check the affected formulas before relying on the results.

How do I replace a word without changing part of a longer word?
Enable Match entire cell contents when the cell must equal the search term. If the word appears within a sentence or longer cell entry, that option will not match the whole cell; review matches individually or choose a more specific search pattern.

Can I undo Replace All?
Excel normally allows you to undo a recent replacement with Ctrl+Z. If you have made additional changes or the operation matters, use a saved copy as a recovery point and verify the workbook after replacement.

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.