The Find and Replace feature lets you change multiple cells at once

Excel's Find and Replace tool searches your spreadsheet for specific text or numbers and swaps them out for something else in one action. Instead of clicking through hundreds of cells to change "2024" to "2025" or fix a misspelled name across an entire sheet, you type what you want to find, type what you want instead, and let Excel do the work. You can search one sheet or your whole workbook, and you can be as broad or as specific as you need.

The feature lives in the Home tab on the ribbon, or you can press Ctrl+H (Windows) or Command+H (Mac) to open it when ready. A dialog box appears with two main fields: one for what you're looking for and one for what you want to replace it with.

Key Takeaways

  • Open Find and Replace with Ctrl+H (Windows) or Command+H (Mac), or click the Home tab and select Find & Replace.
  • Type the text or number you want to find in the first field and what you want to replace it with in the second field.
  • Click "Replace All" to change every match at once, or "Replace" to change them one at a time and skip any you want to keep.
  • Use "Match entire cell contents" if you want to find only cells that contain exactly what you typed, not cells where it appears as part of something else.
  • The tool searches only the current sheet by default — click "Options" and select "Workbook" if you want to search all sheets at once.

Opening Find and Replace and entering your search terms

Press Ctrl+H on Windows or Command+H on Mac. The Find and Replace dialog opens when ready. On the Home tab of the ribbon, you can also click the small arrow next to the Find icon and select "Replace" from the dropdown.

In the "Find what" field, type the exact text or number you want to search for. If you're looking for "John Smith", type that. If you're replacing a year like "2024", type "2024". In the "Replace with" field, type what you want it to become — "Jane Smith" or "2025". Leave the Replace with field empty if you want to delete something rather than swap it for something else.

Before you click Replace, check the Options section at the bottom of the dialog. This is where you control how strict the search is.

Choosing between Replace All and Replace one at a time

Replace All changes every single match in your search area when ready. Use this when you're confident the change is safe — for example, replacing a company name that appears nowhere else, or fixing a consistent typo. Click "Replace All" and Excel tells you how many replacements it made.

Replace (the button without "All") finds the first match and stops. You see it highlighted in the spreadsheet. You can then click "Replace" to change just that one, or "Find Next" to skip it and look at the next match. This takes longer but gives you control — useful when you're not sure every match should change, or when the text you're looking for might mean different things in different places.

If you use Replace one at a time and want to stop partway through, close the dialog. Excel remembers where it was, but you can also press Escape to exit without finishing.

Using Options to search more precisely

Click "Options" in the Find and Replace dialog to see additional controls. The most useful is Match entire cell contents. When this is checked, Excel finds only cells that contain exactly what you typed and nothing else. When it's unchecked, Excel finds your search term anywhere inside a cell.

For example, if you search for "cat" without "Match entire cell contents" checked, it finds "cat", "category", "concatenate", and "scatter". If you check "Match entire cell contents", it finds only cells that say exactly "cat" and nothing more. This prevents accidental replacements in longer words or phrases.

Other options include Match case, which makes the search sensitive to uppercase and lowercase letters (so "John" would not match "john"), and Search, which lets you pick whether to search by rows or by columns. Most of the time you can leave these alone.

Searching the current sheet versus the entire workbook

By default, Find and Replace searches only the sheet you're currently viewing. If your workbook has multiple sheets and you want to search all of them at once, click Options and look for the "Within" dropdown. Select Workbook instead of "Sheet". Now when you click Replace All, Excel searches every sheet in the file.

This is helpful when you have data split across multiple sheets and need to make the same change everywhere. Be extra careful with Replace All when searching the workbook — you're changing potentially hundreds of cells across multiple sheets, and you can't undo it by sheet. If you're not certain, use Replace one at a time instead.

Undoing a Find and Replace if something went wrong

If you click Replace All and realize the change was wrong, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo. Excel reverses the entire replacement in one step, putting everything back the way it was. This works even if you replaced hundreds of cells.

If you've made other changes since the replacement, undo will reverse those too, so you may need to redo some work. This is another reason to use Replace one at a time when you're not completely sure about a change.

Common mistakes and how to avoid them

The most common mistake is forgetting to check "Match entire cell contents" when you mean to find a specific value. If you search for "5" without it checked, you'll match "5", "50", "500", "25", and "350" — anything containing the digit 5. Check the box if you want only cells that are exactly 5.

Another mistake is searching the current sheet when you meant to search the whole workbook, or vice versa. Before you click Replace All, glance at the Options section and confirm the "Within" setting matches what you want. If you're working with multiple sheets, it's straightforward to forget you're only changing one.

Replacing with an empty field (leaving "Replace with" blank) deletes the text. This is useful when you want to remove something, but it's straightforward to do by accident. If you're not sure, use Replace one at a time so you see what's being deleted before it happens.

Frequently Asked Questions

Can I undo a Find and Replace after I've saved the file?

No. Once you save, the undo history is gone. Always press Ctrl+Z (or Command+Z on Mac) when ready if something goes wrong, before you save. If you've already saved, you'll need to manually fix the cells or reopen the file without saving the changes.

What if I want to find something that contains special characters like asterisks or question marks?

In Find and Replace, asterisks and question marks are wildcards — they match any character. If you want to find the literal character, click Options and check "Use regular expressions", then put a backslash before the character (like \* for an asterisk). For most everyday searches, you won't need this.

Can I search for line breaks or invisible characters?

Yes, but it requires regular expressions. Click Options, check "Use regular expressions", and use special codes: \n for a line break, \t for a tab. This is advanced and most people won't need it for basic spreadsheet work.

Does Find and Replace work on formulas or just the values they display?

It searches both. If a cell contains a formula that displays "100", and you search for "100", it will find that cell. If you search for the formula text itself (like "=SUM"), it finds cells containing that formula. Be careful when replacing inside formulas — you can break them accidentally.

What's the difference between Find and Find & Replace?

Find (Ctrl+F) only searches and highlights matches — it doesn't change anything. Find & Replace (Ctrl+H) lets you search and change. Use Find when you just want to locate something; use Find & Replace when you want to change it.