The fastest way to replace text in Excel

Open the spreadsheet, press Ctrl+H (Windows) or Cmd+H (Mac), and the Find & Replace dialog opens. Type the text you want to find in the "Find what" field, type the replacement text in the "Replace with" field, then click "Replace All" to change every instance at once. If you want to replace only certain occurrences, click "Replace" one at a time to review each match before you confirm it.

The Find & Replace tool works across all sheets in your workbook, all cells in a sheet, or just the cells you have selected—depending on what you choose before you open the dialog. This matters: if you select a single column first, then open Find & Replace, it will only search that column.

Key Takeaways

  • Press Ctrl+H (Windows) or Cmd+H (Mac) to open Find & Replace, then type the old text and new text and click Replace All.
  • Use "Replace" instead of "Replace All" if you want to review each match before it changes, which prevents accidental replacements.
  • The search respects your selection—if you select one column first, only that column gets searched.
  • Match Case and Match Entire Cell Contents are unchecked by default, so "cat" will find "Cat", "catalog", and "scatter" unless you check those boxes.

Step-by-step: replacing text one instance at a time

If you want to see each match before it changes, use "Replace" instead of "Replace All". Press Ctrl+H (or Cmd+H on Mac) to open the dialog. Type the text you want to find, type the replacement, then click the "Replace" button. Excel highlights the first match in your sheet. If it is the one you want to change, click "Replace" again. If it is not, click "Find Next" to move to the next match without changing anything.

This method takes longer but protects you from replacing text you did not mean to change. For example, if you search for "sales" and click "Replace All", it will change "sales" inside "wholesale" too—unless you checked "Match Entire Cell Contents" first. Reviewing each match one at a time lets you skip those accidental hits.

Understanding Match Case and Match Entire Cell Contents

By default, Find & Replace ignores capitalization and searches for your text anywhere inside a cell. "cat" will find "Cat", "CAT", "catalog", and "scatter". If you want to match only the exact capitalization, check the "Match Case" box. If you want to match only cells that contain nothing but that text, check "Match Entire Cell Contents".

These two options work together. If you search for "cat" with both boxes checked, Excel will find only cells that contain exactly "cat" in lowercase and nothing else. If you search for "cat" with only "Match Entire Cell Contents" checked, it will find "Cat", "CAT", and "cat" but not "catalog" or "scatter".

Replacing text in a specific column or range

Before you open Find & Replace, select the cells you want to search. Click the column header to select an entire column, or click a cell and drag to select a range. Then press Ctrl+H (or Cmd+H). The Find & Replace dialog will only search the cells you selected.

This is useful when you have the same text in different columns and you want to replace it in only one place. For example, if you have "2024" in both a date column and a product code column, you can select just the date column first, then replace "2024" with "2025" without touching the product codes.

Using wildcards to find patterns

If you want to find text that matches a pattern rather than an exact phrase, you can use wildcards. First, check the "Use Regular Expressions" box (in some versions of Excel, this is called "Use Wildcards"). Then use .* to match any characters, . to match a single character, or ^ and $ to match the start or end of a cell.

For example, to find any cell that starts with "Item" and ends with a number, search for ^Item.*[0-9]$. To find any three-character word, search for ^...$. Regular expressions are powerful but take practice—if you are not sure whether your pattern is correct, test it on a copy of your spreadsheet first.

What to do if you replace text by mistake

If you click "Replace All" and realize you made a mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the change. Excel will reverse the replacement and restore the original text. This works even if you replaced hundreds of cells at once.

If you have already saved the file after the replacement, undo will not work. In that case, you will need to open the previous version of the file if you saved backups, or manually fix the cells. This is why reviewing matches one at a time with the "Replace" button is safer than "Replace All" when you are not certain about the replacement.

Replacing text across multiple sheets

Find & Replace searches all sheets in your workbook by default. If you have a workbook with ten sheets and you search for "old text", it will find and replace that text in all ten sheets unless you stop it. To search only the current sheet, click the "Options" button in the Find & Replace dialog, then look for a setting that says "Search" or "Within" and change it from "Workbook" to "Sheet".

The exact wording and location of this setting varies by Excel version and whether you are using Excel on Windows, Mac, or online. If you do not see an "Options" button, the dialog may already be expanded—look for a dropdown menu that says "Search" or "Within" near the top of the dialog.

Frequently Asked Questions

Can I replace text with nothing to delete it?

Yes. Leave the "Replace with" field empty and click "Replace All". Excel will remove every instance of the text you searched for. For example, to remove all spaces from a column, search for a space character and leave "Replace with" blank.

What if Find & Replace says "no matches found"?

The text you are searching for is not in your spreadsheet, or it is spelled differently than you typed. Check your spelling, and make sure you are searching the right sheet or range. If you have "Match Case" checked, also try unchecking it—the text might be capitalized differently than you expect.

Can I replace text in formulas?

Yes, but be careful. Find & Replace will change text inside formulas just like it changes text in regular cells. If you search for a number that appears in both cell values and formulas, you might accidentally break a formula. Test on a copy first, or use "Replace" one at a time to review each match.

Does Find & Replace work on hidden rows or columns?

Yes. Even if rows or columns are hidden, Find & Replace will search them and replace text in them. If you want to exclude hidden cells, unhide them first, select only the visible cells you want to search, then open Find & Replace.