Open Find and Replace with the keyboard shortcut

The fastest way to open Find and Replace in Excel is to press Ctrl+H on Windows or Command+H on Mac. This opens a dialog box where you can type what you want to find and what you want to replace it with. The dialog stays open until you close it, so you can make multiple replacements without reopening it each time.

If the keyboard shortcut does not work, you can also reach Find and Replace through the menu. Click the Home tab, then look for Find & Select in the upper right corner of the ribbon. Click it and choose Replace from the dropdown menu.

Key Takeaways

  • Press Ctrl+H (Windows) or Command+H (Mac) to open the Find and Replace dialog when ready.
  • Type the text you want to find in the first field and the replacement text in the second field, then click Replace All to change every instance at once.
  • Use the Match entire cell contents option to avoid replacing partial matches within longer text strings.
  • Click Replace to change one instance at a time, or Replace All to change every match in your spreadsheet in one action.
  • The Options button reveals additional filters like searching only in formulas or values, and matching case sensitivity.

Type what you want to find and what to replace it with

In the Find and Replace dialog, the top field is labeled Find what:. Type the exact text, number, or phrase you want to locate. The second field is labeled Replace with:. Type what you want to put in its place. If you want to delete something entirely, leave the Replace with field empty and click Replace All.

For example, if you have a column of dates written as "01/15/2024" and you want to change them to "01-15-2024", type "01/15/2024" in Find what and "01-15-2024" in Replace with. Excel will find every exact match of that text and swap it out.

Replace one cell at a time or all at once

After you type your find and replace text, you have two choices. Click the Replace button to change only the first match Excel finds. Excel will highlight that cell and show you what it found. You can then click Replace again to change that instance and move to the next match, or click Find Next to skip it without replacing.

If you are confident your search term is specific enough, click Replace All to change every match in the entire spreadsheet at once. Excel will tell you how many replacements it made. This is much faster when you are changing something that appears dozens or hundreds of times, but use it carefully—once you click it, the change happens to every match when ready.

Use Options to search only formulas or values

Click the Options button in the Find and Replace dialog to reveal additional search settings. One of the most useful is the dropdown that says Search. By default it is set to By Rows, which searches left to right across each row. You can change it to By Columns if you prefer to search top to bottom down each column, though this rarely matters for the actual results.

More importantly, look for the Look in: dropdown. If you set it to Formulas, Excel will search the actual formulas in your cells, not just the displayed values. If you set it to Values, it searches only what you see on screen. This matters when a cell contains a formula that produces a number—searching for that number in Formulas mode will not find it, but Values mode will.

Match entire cells to avoid partial replacements

By default, Find and Replace will match text anywhere inside a cell. If you search for "cat" and Replace All, it will change "cat", "catalog", "concatenate", and "category" all at once. To prevent this, check the box labeled Match entire cell contents. Now Excel will only replace cells that contain exactly "cat" and nothing else.

This option is essential when you are working with codes, product numbers, or any data where a partial match would be wrong. For instance, if you want to replace the product code "A1" but not "A10" or "A100", turn on Match entire cell contents before you search.

Use case sensitivity when uppercase and lowercase matter

By default, Excel treats uppercase and lowercase letters as the same. If you search for "smith", it will find "Smith", "SMITH", and "smith" all together. If your data requires you to keep the case consistent—for example, if you have a list of names where some are capitalized and some are not—check the box labeled Match case.

Once Match case is turned on, searching for "smith" will only find lowercase "smith" and will not touch "Smith" or "SMITH". This is useful in technical data, code lists, or any spreadsheet where the capitalization carries meaning.

Undo a replacement if you made a mistake

If you click Replace All and realize the replacement was wrong, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo. Excel will reverse the entire Replace All action and restore your original text. This works as long as you have not made other changes since the replacement.

For this reason, it is often safer to click Replace once or twice first to see what Excel finds before you commit to Replace All. This way you can verify that your search term is finding the right cells and not matching things you did not expect.

Frequently Asked Questions

Can I use Find and Replace to search across multiple sheets at once?

No. Find and Replace searches only the sheet you are currently viewing. If you need to replace text in multiple sheets, you must open each sheet and run Find and Replace on it separately. Some users copy all sheets into one temporary sheet, do the replacement, then copy the results back, but this is time-consuming and error-prone.

What if I want to replace text only in a specific column?

First, click on the column header to select the entire column. Then open Find and Replace with Ctrl+H. Excel will search only within the selected column. This prevents accidental replacements in other parts of your spreadsheet.

Can I use wildcards or patterns in Find and Replace?

Yes, but you must turn on Regular expressions in the Options menu first. This is an advanced feature that lets you search for patterns like "any three digits" or "text that starts with A". The syntax is complex, so check Excel's help documentation if you need this feature.

Why did Replace All say it made zero replacements?

The most common reason is that your search text does not match anything in the spreadsheet exactly. Check for extra spaces, different punctuation, or capitalization. You can also click Find Next first to see if Excel can locate the text at all before you try Replace All.

Does Find and Replace work on cell formatting or only text?

Find and Replace works on text and numbers only. To find and replace formatting (like cell color, font style, or number format), you must use the Format button in the Find and Replace dialog, which is an advanced feature. For most users, Find and Replace handles text content, not appearance.