How to Find and Replace Words in Excel

The fastest way to change multiple words at once

Excel's Find & Replace tool lets you swap out one word or phrase for another across your entire spreadsheet in seconds. Open the Find & Replace dialog by pressing Ctrl+H on Windows or Command+H on Mac. Type the word you want to find in the "Find what" field, type the replacement word in the "Replace with" field, then click "Replace All" to change every instance at once. If you want to be more careful and review each change before it happens, click "Replace" one at a time instead.

This matters because manually editing hundreds of cells takes hours and invites typos. A single Find & Replace command catches every occurrence, including ones you might miss while scrolling. It also works across multiple sheets if you need it to, and you can undo the whole operation with Ctrl+Z if something goes wrong.

Key Takeaways

Press Ctrl+H (Windows) or Command+H (Mac) to open Find & Replace, then type the old word and new word and click Replace All.
Use "Replace" one at a time instead of "Replace All" if you want to review each change before it happens.
The "Match case" checkbox makes the search case-sensitive, so "Smith" will not match "smith".
The "Match entire cell contents" option only replaces cells that contain exactly that word and nothing else.
You can undo a mass replacement with Ctrl+Z if you change your mind.

Setting up a basic find and replace

Open your spreadsheet and press Ctrl+H (or Command+H on Mac). A dialog box appears with two main fields: "Find what" and "Replace with". Type the exact word or phrase you want to find in the first field. If you are replacing "John" with "Jonathan", type "John" in the Find field and "Jonathan" in the Replace field.

Before you click anything, decide whether you want to replace every instance at once or review them one by one. If you click "Replace All", Excel changes every match in the entire sheet when ready. If you click "Replace", Excel finds the first match and stops, letting you decide whether to replace it. Click "Replace" again to move to the next match. This slower method is safer when you are not completely sure the word appears only in the places you want to change it.

Using Match Case and other search options

The Find & Replace dialog has checkboxes for different search rules. Match case makes the search case-sensitive, so searching for "Smith" will not find "smith" or "SMITH". Turn this on if you need to distinguish between uppercase and lowercase versions of the same word.

Match entire cell contents only replaces cells that contain exactly that word and nothing else. If you search for "John" with this box checked, it will replace a cell that says only "John" but not a cell that says "John Smith" or "John's". This is useful when you want to avoid accidentally changing part of a longer phrase.

You can also search in a specific column or range instead of the whole sheet. Select the cells or column you want to search before opening Find & Replace, and Excel will limit the search to just that area. This prevents accidental changes in parts of the spreadsheet you did not mean to touch.

Replacing numbers and special characters

Find & Replace works on numbers and symbols the same way it works on words. If you want to change all instances of "2024" to "2025", type those numbers in the Find and Replace fields. If you want to remove all commas from a column of numbers, type a comma in the Find field and leave the Replace field empty, then click Replace All.

Special characters like asterisks, question marks, and parentheses can be tricky because Excel treats some of them as wildcards. If you want to find a literal asterisk instead of using it as a wildcard, check the "Regular expressions" box (in some versions of Excel) or escape the character with a backslash. For most everyday replacements, you will not need to worry about this — just type the character you want to find and it will work.

Undoing a replacement you did not mean to do

If you click "Replace All" and when ready realize you made a mistake, press Ctrl+Z to undo the entire operation. Excel will restore all the cells to their original state. This works even if you replaced hundreds of cells at once.

If you did not notice the mistake right away and have done other work since the replacement, you may not be able to undo it. This is why reviewing changes one at a time with the "Replace" button is safer when you are uncertain. It takes longer, but you catch problems before they spread across your whole spreadsheet.

Finding and replacing across multiple sheets

If your workbook has multiple sheets and you want to search all of them at once, open Find & Replace and look for a dropdown that says "Sheet" or "Search in". Change it from "This Sheet" to "All Sheets" or "Workbook" depending on your version of Excel. Then run your find and replace as normal — it will search every sheet in the file.

If you only want to search certain sheets, you will need to do the replacement one sheet at a time. Click on the first sheet tab, open Find & Replace, run it, then move to the next sheet and repeat. This takes longer but gives you more control over which sheets get changed.

When Find & Replace is not the right tool

Find & Replace works well for straightforward word swaps, but it has limits. If you need to change a word only in certain rows or columns, or only when it appears next to another specific word, you may need a formula instead. For example, if you want to replace "John" with "Jonathan" only in cells where the next column says "Manager", Find & Replace cannot do that — you would need to use a formula like IF or SUBSTITUTE.

Find & Replace also cannot change the formatting of cells, only the text inside them. If you want to make all instances of a word bold or red, you will need to use conditional formatting or manual formatting instead. For most everyday tasks like correcting misspellings, updating dates, or swapping out old names for new ones, Find & Replace is the fastest and safest option.

Frequently Asked Questions

What if I only want to replace the word in one column?

Select that column before opening Find & Replace. Click on the column header to select the entire column, then press Ctrl+H. The search will only look in the cells you selected. If you want to search only a few cells, click the first one, hold Shift, and click the last one to select the range.

Can I replace a word with nothing to delete it?

Yes. Type the word you want to remove in the Find field and leave the Replace field empty. Click Replace All and Excel will delete every instance of that word. Be careful with this — if you want to remove "the" from a sentence, it will remove every "the" in the entire sheet, even ones you might not have noticed.

Does Find & Replace work on formulas or only on text?

It works on both. If you have a formula that says =SUM(A1:A10) and you want to change it to =SUM(B1:B10), you can use Find & Replace to swap A for B. Be very careful with this because changing part of a formula can break it. Review each change one at a time instead of using Replace All.

What if the word I am looking for appears in different ways?

If you need to find "color" and "colour" at the same time, you will need to do two separate replacements — one for each spelling. Find & Replace does not have a way to search for multiple variations in one go. Do the first replacement, then open Find & Replace again and do the second one.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.