Excel Find and Replace: How to Search and Change Data

In Excel for Microsoft 365 on Windows, press Ctrl+H, enter the text to find and its replacement, then choose Replace or Replace All. On Mac, open Edit > Find > Replace if available in your Excel menu; the ribbon also provides the Replace command. Check the search scope and options before replacing many cells, because a broad replacement can alter data or formulas you did not intend to change.

What Find and Replace Does

Find and Replace searches worksheet content for a specified character sequence and can substitute another sequence. It is useful for correcting a recurring spelling error, changing a product code, standardizing labels, or removing a repeated fragment from many cells. For instance, replacing the old department label North Sales with Sales North can update matching entries across a sheet without editing each cell individually.

Finding text does not necessarily mean Excel will search only what you see on the screen. A cell might display a calculated result while containing a formula, or display a date formatted differently from its underlying value. Search options determine what Excel examines, and scope options determine where it looks. Those details matter when a workbook contains formulas, hidden data, multiple worksheets, or repeated values with different meanings.

Find and Replace is a text-search tool, not a general data-cleaning system. It does not understand that two different spellings are equivalent, infer that a code belongs to a particular customer, or validate whether a replacement is correct. Treat each replacement as an edit to the workbook and review the affected results.

How to Find and Replace in Excel

On Windows, open the worksheet and press Ctrl+H. Alternatively, use Home > Find & Select > Replace. Enter the existing text in Find what and the new text in Replace with. Select Find Next to inspect a match, Replace to change the current match, or Replace All to update every match within the chosen search scope.

Save the workbook, especially before a replacement that may affect many cells.
Select the relevant range if you want to limit the operation to particular cells. If you do not select a range, Excel searches the worksheet.
Open the Replace tab of the Find and Replace dialog, enter the search and replacement text, and review the options.
Use Find Next to check representative matches before changing anything. If the results are correct, use Replace All or continue with individual replacements.
Read Excel’s confirmation message, then inspect the changed cells and any dependent totals, charts, or formulas.

In the desktop version for Mac, menu labels and dialog placement can vary somewhat by release. Use the Edit menu’s Find commands or the Home tab’s Find & Select controls to open Replace. The Mac equivalents for common shortcuts differ: Command+Z undoes an edit, while Excel for Windows uses Ctrl+Z. If a shortcut does not open the expected dialog on your Mac, use the menu rather than assuming the Windows shortcut applies.

Choose the Search Scope Carefully

Before replacing, decide whether the target is a selected range, the current worksheet, or the whole workbook. The dialog’s Within setting can switch between Sheet and Workbook. Workbook-wide searches are convenient when a label appears on several tabs, but they make it easier to change an unrelated use of the same text. A word such as Draft might appear in a status column, a note, and a formula; those matches may not all deserve the same replacement.

A selected range is useful for local corrections, such as changing one supplier’s old code in a specific column. Select the cells first, then open Replace and confirm the selection is the intended scope. If you are unsure how Excel will interpret the selection, test with Find Next before using Replace All. Also check hidden rows and columns: hidden content can still be part of the search range and may be changed even though it is not currently visible.

Excel’s search order can be set to search by rows or by columns. This usually affects the order in which matches are visited rather than which cells qualify. When there are many results, search order can make manual checking more convenient, but it is not a substitute for limiting the scope.

Match Whole Cells, Case, and Wildcards

The Replace dialog includes options that decide how strictly Excel compares a search term. Match case distinguishes uppercase and lowercase letters, so a search for north will not necessarily treat North as a match when the option is selected. Match entire cell contents limits matches to cells whose full content is the search term. Without that option, Excel can find a term inside a longer entry. Searching for cat, for example, could find the same letters inside a longer word.

Excel’s Find and Replace supports wildcard characters in searches. An asterisk (*) represents any number of characters, while a question mark (?) represents one character. These are useful for patterns, but they can also make a search much broader than expected. For example, a search for AB* can match cell content beginning with AB followed by additional characters. To search for a literal asterisk, question mark, or tilde, precede it with a tilde: ~*, ~?, or ~~.

Wildcards are not regular expressions. A regular-expression pattern copied from another tool will not automatically work in Excel’s standard Find and Replace dialog. If a pattern-based replacement is complex, first test the search on a small range and review the results one by one. Avoid using a broad wildcard with Replace All until you understand exactly which entries it matches.

Searching Cell Values, Formulas, and Other Content

Use the dialog’s Look in setting to choose what Excel searches, such as formulas, values, or notes where those options are available in the version you are using. A cell containing a formula may show a number or label as its result. Searching in formulas can locate text embedded in the formula itself; searching in displayed values is more suitable when the visible result is what you want to inspect. Option names and available choices can differ between Excel releases.

Be especially cautious when replacing text in formulas. A replacement can change part of a formula’s expression, a sheet reference, or a text string used by that formula. For example, changing a code that appears in both worksheet labels and formula references may have unintended consequences. After a formula-level replacement, check for error values such as #REF! and confirm that key totals still make sense. For a small number of formula edits, editing the formulas individually is often safer than a workbook-wide replacement.

Dates and numbers have an underlying value and a display format. A date may appear as 03/04/2026 in one cell and 4-Mar-2026 in another even though the stored date is the same. Find and Replace is not always the best way to convert dates or numeric data, because searching the visible text may not correspond to the stored value. For structured conversions, use appropriate cell formatting or data-cleaning steps, and verify the resulting values rather than relying only on how they look.

Replace One Match or Replace All?

Replace changes the current match and lets you continue through results. This is the safer choice when a term has multiple meanings or when each occurrence needs judgment. Replace All is faster for a consistent correction, such as changing a misspelling in a dedicated product-name column, but it may affect every match in the search scope at once. Excel reports how many replacements it made; that count is a useful check, not proof that every change was appropriate.

A practical approach is to run Find All first when the dialog offers it, inspect the matching cells, and then replace. If the matching list includes unexpected tabs or columns, narrow the scope or refine the search term. For a large workbook, consider saving a separate copy before a high-impact replacement. Normal Find and Replace edits can usually be undone with Ctrl+Z on Windows or Command+Z on Mac, but do not rely on Undo as your only backup after continuing to edit the workbook.

Common Problems and How to Fix Them

No matches appear: Check spelling, spaces, case settings, selected range, and the Within and Look in choices. A cell may contain a formula while displaying a different value.
Too many cells change: The search may match part of longer text, or the scope may be set to the whole workbook. Use Match entire cell contents where appropriate and restrict the range.
Some similar entries remain: Capitalization, extra spaces, punctuation, or different spellings may make them distinct. Search separately for each variant rather than assuming Excel treats them as the same.
Find and Replace changes formulas unexpectedly: Review the Look in setting and avoid formula searches unless you intend to edit formula text. Undo promptly if the result is wrong.
The replacement seems to miss hidden information: Check for hidden rows, hidden columns, other worksheets, and notes. Confirm the workbook-wide scope and relevant search options.
The replacement is unavailable or cells do not change: The sheet may be protected or the affected cells may not be editable. Check worksheet protection and permissions before trying another method.

Merged cells and highly formatted sheets can also make results harder to interpret. A match may be in a cell that is not obvious from the visible layout, especially when columns are hidden or a value is displayed through formatting. When the worksheet is complex, use Find Next and inspect the cell address or the formula bar before editing.

When to Use Another Method

Find and Replace is best for direct, repeatable substitutions. It is less suitable when you need to split text into columns, remove inconsistent spaces across a dataset, map many old codes to different new codes, or transform values according to rules. For those jobs, Excel’s Text to Columns feature, Power Query, or formulas may offer a more controlled process. The right choice depends on whether the change is a simple substitution or a broader transformation.

For example, replacing a single obsolete region label across a known column is a natural use of Replace. If a column contains a mixture of old labels that each map to a different new label, applying one global replacement at a time can be error-prone. A mapping table and a lookup-based workflow can make the changes easier to audit. If the workbook is a recurring report, Power Query may also help make the cleanup repeatable during data refreshes.

Do not use Find and Replace to alter a cell’s appearance when the underlying content should stay the same. To change how dates, percentages, or numbers display, change the number format instead. Conversely, changing a displayed format will not correct a misspelled text value. Identifying whether the problem is content, calculation, or presentation is the first step toward choosing a reliable fix.

Frequently Asked Questions

What is the shortcut for Find and Replace in Excel?
In Excel for Microsoft 365 on Windows, Ctrl+H opens Replace. On Mac, use the Edit menu’s Find commands or the Home tab’s Find & Select controls if the shortcut differs in your release.

Can I replace text in the entire Excel workbook?
Yes. In the Find and Replace dialog, set Within to Workbook rather than Sheet. Review matches and confirm the scope first, since the same text may have different meanings on different tabs.

How do I replace only a whole-cell match?
Open Replace, expand its options if needed, and select Match entire cell contents. That prevents a search term from matching only part of a longer cell entry.

Can Excel Find and Replace use wildcards?
Yes. An asterisk matches any number of characters, and a question mark matches one character. Use a tilde before a wildcard character when you want to find it literally, and test broad patterns before using Replace All.

Can I undo Replace All?
Usually, press Ctrl+Z on Windows or Command+Z on Mac soon after the replacement. Undo history can be affected by later actions, so save a copy before a substantial edit and verify the restored cells if you undo.

Why does Excel find a value but not replace it?
Check whether the worksheet is protected, whether the cell is editable, and whether your search options target formulas, values, or the intended range. A formatted display value may also differ from the underlying content Excel is searching.

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.