Open Find and Replace with Ctrl+H

The fastest way to find and replace in Excel is to press Ctrl+H on your keyboard. This opens the Find and Replace dialog box, which is where all the work happens. On a Mac, use Cmd+H instead.

If you prefer using the menu, go to the Home tab at the top of Excel, then click Find & Select in the far right corner, and choose Replace from the dropdown. Both methods open the same dialog.

Key Takeaways

  • Press Ctrl+H to open Find and Replace; type what you want to find in the first box and what you want it to become in the second box.
  • Click Replace All to change every instance at once, or Replace to change them one by one and skip any you want to keep.
  • Use Match entire cell contents if you want to replace only cells that contain exactly that text and nothing else.
  • The Options button lets you search only in formulas, values, or comments, and you can limit the search to a range you select first.
  • Excel shows you how many replacements it made, so you can undo the whole operation with Ctrl+Z if something went wrong.

Type What to Find and What to Replace It With

In the Find what: box, type the text or number you want to search for. In the Replace with: box, type what you want it to become. If you want to delete something entirely, leave the Replace with box empty and click Replace All.

For example, if you have a column of phone numbers formatted as "555-1234" and you want them as "(555) 1234", you would find "555-" and replace it with "(555) ". Excel will change every match.

Choose Replace All or Replace One at a Time

The Replace All button changes every instance of your search term in one click. This is fast when you are confident the replacement is correct everywhere. Excel will tell you how many replacements it made at the bottom of the dialog.

The Replace button (without "All") changes one instance at a time. Excel highlights the first match, and you decide whether to click Replace to change it or Find Next to skip it and look at the next one. This is safer when you want to check each change before it happens, or when some instances should stay the way they are.

Limit Your Search with Match Entire Cell Contents

By default, Excel finds your search term anywhere inside a cell. If you search for "cat", it will find "cat", "catalog", "concatenate", and "scatter". To find only cells that contain exactly "cat" and nothing else, check the box labeled Match entire cell contents before you search.

This is useful when you have a column of product codes or names and you want to replace only the exact matches. For instance, if you search for "USA" with this box checked, it will not change "USAA" or "USA Inc"—only cells that say "USA" alone.

Search in Formulas, Values, or Comments Only

Click the Options button to reveal more choices. The Search in: dropdown lets you pick whether Excel looks in formulas, values, or comments. Most of the time you want Values, which searches the numbers and text you see on the screen.

Choose Formulas if you want to find and replace parts of the actual formulas in your cells—for example, if you want to change a cell reference from "A1" to "B1" inside many formulas. Choose Comments only if you are searching the notes people have added to cells.

Select a Range First to Search Only Part of Your Sheet

If you want to replace text in only certain columns or rows, select that range before you open Find and Replace. Highlight the cells you want to search, then press Ctrl+H. Excel will search only inside your selection.

This is a safety measure when you have similar text in different parts of your sheet and you want to change only one section. For example, if you have customer names in columns A through C and product names in columns D through F, you can select just A through C, then replace without touching the product data.

Undo the Replacement if Something Went Wrong

If you click Replace All and realize the change was not what you wanted, press Ctrl+Z when ready to undo. Excel will reverse every replacement that just happened and put your data back the way it was. You can undo multiple times if you need to go back several steps.

This is why Replace All is actually safer than it sounds—you can always undo it. If you are nervous about a large replacement, do it anyway, check the results, and undo if needed. It takes seconds.

Frequently Asked Questions

Can I use Find and Replace with wildcards or patterns?

Yes. Check the Use regular expressions box in Options to search for patterns instead of exact text. For example, .* means any character repeated any number of times. This is advanced and takes practice, but it lets you find things like "any five-digit number" or "any cell starting with Q".

What if I want to replace only in one column?

Click the column header to select the entire column, then open Find and Replace. Excel will search only in that column. You can also select a smaller range—just highlight the cells you want before pressing Ctrl+H.

Does Find and Replace work across multiple sheets?

No, it searches only the sheet you are currently on. If you need to replace text in multiple sheets, you have to run Find and Replace separately on each one. There is no built-in way to search all sheets at once.

Can I replace with a formula or a function?

No. Find and Replace works only with text and numbers, not formulas. If you need to replace cell contents with a formula, you will need to use a different method like copy-paste special or a helper column with a formula.

What happens if I search for something that does not exist?

Excel will show a message saying "Search key not found" and nothing will change. This is harmless—just close the message and try a different search term or check your spelling.