Does Excel Have Find and Replace? How to Use It

Yes. Microsoft Excel for Microsoft 365 on Windows has Find and Replace: press Ctrl+H, enter the text to find and its replacement, then choose Replace or Replace All. You can search a worksheet or a workbook, and options such as Match case and Match entire cell contents help control what gets changed.

What Find and Replace Does

Find and Replace searches cell contents for text or values and, if you ask it to, substitutes a different entry. It is useful for correcting repeated typos, changing a product code, updating a department name, or replacing a symbol throughout a table. For example, if a worksheet uses the old label North Division and the new label is Northern Division, Replace All can update matching cell contents without editing each cell individually.

The feature is not the same as a general search across every part of an Excel file. It primarily works with worksheet cells, and the chosen search scope matters. It does not automatically inspect every object, such as text inside a picture, or every workbook component. If a result is not found, it may be because the text is outside the selected range, on another sheet, or stored in a part of the workbook that cell search does not cover.

How to Find or Replace Text in Excel

On Windows, Ctrl+F opens Find, while Ctrl+H opens the Replace tab of the Find and Replace dialog. You can also use the ribbon: choose Home > Find & Select > Replace. To search without changing anything, enter the term in Find what and choose Find Next or Find All. To make a change, enter the new text in Replace with, then select Replace for one match or Replace All for every match in the selected scope.

If you only want to search a particular block, select that range first. Otherwise, Excel searches the active worksheet by default.
Open the Replace tab and enter the existing text in Find what and the desired text in Replace with.
Review the search options before making a broad change, especially the scope and Match entire cell contents setting.
Choose Find Next to inspect matches one at a time, or choose Replace All when you are confident the scope and criteria are right.
Read Excel’s completion message, then check representative results. Use Ctrl+Z promptly if an ordinary replacement changed something you did not intend.

On a Mac, use the Find and Replace controls on the Home tab or the Edit menu; menu labels and shortcut behavior can vary with the Excel version and keyboard settings. Excel for the web also provides Find and Replace from Home > Find & Select > Replace, though its interface and available options can differ from the Windows desktop app. If a shortcut does not open the expected dialog on Mac or in a browser, use the ribbon or menu rather than assuming the feature is missing.

Choose the Right Search Scope and Options

Search scope is one of the most important settings. Within lets you choose the current sheet or the workbook. A workbook search is helpful when a label appears on several tabs, but it can also change cells you had not considered. If you have selected a range, Excel may limit the search to that selection. Before using Replace All, confirm whether you mean one block, one worksheet, or the entire workbook.

The dialog’s options can refine what counts as a match. Match case treats uppercase and lowercase letters as different; without it, Excel generally searches without distinguishing case. Match entire cell contents requires the whole cell entry to equal the search term. For instance, searching for cat with that option enabled will not match a cell containing cat food. With it disabled, the text can match part of a longer entry.

Look in controls what Excel searches within, such as formulas or displayed values, depending on the version and dialog. This distinction matters when a cell displays 125 but contains a formula that calculates 125. A search for 125 may behave differently depending on whether Excel is looking at the formula or its result. Use the option that corresponds to what you need to locate, and inspect a match before replacing it if the data is important.

Find and Replace can also use formatting criteria through the Format controls in the dialog. That can help locate cells with a particular format, but it is different from searching only by visible text. If a previous search applied a format criterion, clear or review it when later searches unexpectedly miss ordinary text. Options can persist between searches, so a dialog that worked yesterday may still carry a setting that changes today’s results.

Use Wildcards for Patterns

Excel supports wildcard characters in the Find what field, which can help find text that varies slightly. An asterisk represents any number of characters, while a question mark represents a single character. For example, searching for inv* may find entries beginning with inv, such as invoice and inventory. Searching for p?t can match entries such as pat or pet, because the question mark stands for one character.

To search for a literal asterisk, question mark, or tilde rather than use its wildcard meaning, precede it with a tilde. For example, ~? searches for an actual question mark. Wildcards are useful for locating groups of entries, but they make Replace All more powerful and potentially less precise. First use Find All or Find Next to inspect which cells match. Excel’s standard Find and Replace is not a regular-expression editor, so do not expect it to understand more advanced pattern syntax.

What Can Be Replaced, and What Should You Check?

Excel can replace text in ordinary cell entries, and it can also search formulas when the relevant Look in setting is selected. That flexibility is useful, but changing formula text can alter a calculation rather than just a displayed label. If a formula contains the text or characters you are replacing, examine its structure before replacing across a sheet. A change to a reference, function name, or text string inside a formula may produce a different result or an error.

Dates and numbers can be less straightforward than plain words. Excel stores dates as numeric values and displays them according to cell formatting, so the date you see on screen may not be the exact underlying content searched. Likewise, a number may display with commas or currency formatting even though its stored value is different. For a targeted edit, consider whether you are changing a literal value, a formula, or only how a value is displayed. A number format change is not the same operation as replacing cell content.

Replacing a short string can also alter longer words or identifiers. If the Find what entry is 10 and Match entire cell contents is off, Excel could match those digits inside a longer code such as 1057. Use a longer, more distinctive search term when possible, or turn on Match entire cell contents if the entire cell should be an exact match. Review examples before committing a large replacement.

Common Problems and Safer Troubleshooting

No results appear: Check whether you are searching the right sheet or workbook, whether a range is selected, and whether Look in is set appropriately. Also review Match case, Match entire cell contents, and any saved format criteria.
Only some entries change: The entries may not be identical. Differences in spacing, punctuation, capitalization, formulas, or hidden characters can affect a search. Search a distinctive portion of an entry and inspect the cell contents before changing data.
Too many cells change: Undo immediately with Ctrl+Z on Windows, then repeat with a narrower selection, a more specific term, or Match entire cell contents. Do not save over the only copy of important data until you have checked the outcome.
The displayed result seems unchanged: The cell might contain a formula, or a format may control how its value appears. Check the formula bar and the Look in setting before assuming Replace All failed.

For high-impact changes, save a separate copy of the workbook first. You can also use Find All to list matches, inspect the affected cells, and then replace only selected instances. That extra review is worthwhile for customer records, imported data, codes, or formulas where one unintended edit could be difficult to spot. Normal Find and Replace changes can generally be undone with Ctrl+Z, but it is still safer to verify the scope before running Replace All than to rely on undo.

Find and Replace Compared with Other Excel Tools

Find and Replace is best for direct, deliberate edits to existing cell contents. It is not always the right tool for transforming data. Text to Columns, available from the Data tab, can split one column into multiple columns. Flash Fill can infer a pattern from examples in supported desktop versions. Formulas can create a cleaned or transformed result while leaving the source data untouched, which is often preferable when the original values need to be preserved.

For example, if a column consistently contains the typo Colour: blue and the intended text is Color: blue, Replace All is a straightforward correction. If a column contains mixed names that need to be split into first and last names, a global replacement is not a suitable substitute for a parsing tool. Similarly, removing leading or trailing spaces from many imported entries may call for a cleanup method rather than replacing a single visible space, since spaces can also appear legitimately inside names and phrases.

Excel’s Find command is also distinct from filtering. Find locates matching content; a filter temporarily displays rows meeting criteria. If the goal is to review every record with a certain status before editing, a filter can make the review easier. You can then make a deliberate change, while remembering that Replace All is still governed by its own search scope and options.

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, use the Find and Replace controls from the ribbon or Edit menu if the Windows shortcut does not apply to your keyboard setup.

Can Excel replace text in the whole workbook?
Yes. In the Find and Replace options, set Within to Workbook rather than Sheet, if that option is available in your version. Check the scope before choosing Replace All, because the change can affect matching cells on multiple worksheets.

Can I replace only a complete cell value?
Yes. Turn on Match entire cell contents in the dialog. A search for blue will then target a cell whose entire content is blue, rather than also matching a longer entry such as blue shirt.

Can Find and Replace change formulas?
It can search formula text when Look in is set to Formulas, and replacing matching formula text can change how a calculation works. Review the formulas and use a copy of the workbook before making broad formula edits.

Can I undo Replace All?
For an ordinary replacement in the desktop app, Ctrl+Z on Windows usually undoes the operation. Check the results promptly, and save a backup before a large or consequential change rather than treating undo as your only safeguard.

Does Excel Find and Replace support wildcards?
Yes. In Find what, 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 search for that character literally.

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.