Use the Find & Replace dialog to swap one word for another across your whole sheet

Excel's Find & Replace feature lets you change a word, phrase, or number everywhere it appears in your spreadsheet at once. You open it with Ctrl+H (Windows) or Command+H (Mac), type what you want to find and what you want to replace it with, then choose whether to change one cell or the entire sheet. The tool works on text, numbers, and partial matches — so you can replace "cat" with "dog" and catch "catalog" too, unless you tell it not to.

This is much faster than clicking through cells one by one, and it shows you how many replacements it made so you know the change worked. The dialog also has options to match exact words only, search by column or row, and even undo everything if you change your mind.

Key Takeaways

  • Open Find & Replace with Ctrl+H (Windows) or Command+H (Mac), then type the word to find and the word to replace it with.
  • Click "Replace All" to change every match in the sheet at once, or "Replace" to change one at a time and review each change.
  • Check "Match entire cell contents" if you want to replace only cells that contain exactly that word, not partial matches.
  • Use "Find All" first to see how many matches exist before you replace them, so you can catch mistakes.
  • Press Ctrl+Z when ready after if you replace the wrong thing — Excel remembers the change and can undo it.

Open Find & Replace and enter your search terms

Press Ctrl+H on Windows or Command+H on Mac. The Find & Replace dialog box opens. In the "Find what:" field, type the exact word or phrase you want to change. In the "Replace with:" field, type what you want it to become.

If you are replacing a number, type the number the same way it appears in the cells — for example, if a cell shows "2024" but you want "2025", type those numbers exactly. Excel is case-sensitive by default, so "Cat" and "cat" are treated as different words. If you want to match both, leave the case setting alone; if you want only lowercase "cat" to change, you can adjust this in the options.

Choose between Replace All and Replace one at a time

Replace All changes every match in the entire sheet when ready. This is the fastest option if you are confident the word you are replacing appears only where you want it to. Excel shows a message telling you how many replacements it made.

Replace (without "All") changes one match at a time. Excel highlights the first match in the sheet, and you decide whether to replace it. Click "Replace" to change that one and move to the next, or "Find Next" to skip it. This takes longer but lets you review each change before it happens, which is safer if the word appears in places you might not expect.

Start with "Find All" if you are unsure. This shows you a list of every cell that contains the word, so you can see the matches before you change anything. If the list looks right, go back and click "Replace All".

Use Match Entire Cell Contents to avoid partial matches

By default, Find & Replace matches part of a word. If you search for "cat", it will change "cat", "catalog", "category", and "concatenate" all at once. This is useful when you want that behavior, but dangerous when you do not.

To change only cells that contain exactly the word you are looking for, check the box labeled "Match entire cell contents" (the exact name varies slightly by Excel version — look for "Entire cell contents" or "Whole words only"). Now searching for "cat" will change only cells that say exactly "cat" and nothing else. This prevents accidents.

Search within a specific range instead of the whole sheet

If you want to replace words in only part of your spreadsheet, select those cells first before you open Find & Replace. Highlight the range you want to search — click the first cell, hold Shift, and click the last cell, or drag to select a block. Then press Ctrl+H. The dialog will search only within your selection.

This is useful when you have multiple sheets or when you want to change a word in one column but not another. If you do not select anything, Find & Replace searches the entire active sheet by default.

Undo a replacement if you made a mistake

If you click "Replace All" and realize you replaced the wrong thing, press Ctrl+Z when ready. Excel undoes the entire replacement and restores the original text. This works even if you replaced hundreds of cells at once.

If you have already done other work after the replacement, undo will reverse that work too, so be careful. The safest approach is to use "Replace" (one at a time) the first time you use Find & Replace on important data, so you can catch mistakes as they happen.

Search for special characters and line breaks

Find & Replace can search for things that are not regular text. To find a line break within a cell, type Ctrl+J in the "Find what:" field (on Windows) or use the special code ^l (that is a caret and lowercase L). To find a tab character, use Ctrl+Tab or the code ^t.

If you need to find a question mark, asterisk, or other symbol that has special meaning in Excel, put a tilde (~) before it — so to find a literal question mark, type ~?. This tells Excel to treat the symbol as text, not as a wildcard.

Frequently Asked Questions

Can I replace text in multiple sheets at once?

No, Find & Replace works on one sheet at a time. You must repeat the process for each sheet. However, you can select all sheets first by right-clicking a sheet tab and choosing "Select All Sheets", then use Find & Replace — it will explore to every selected sheet in one action.

What if I want to replace only the first occurrence of a word?

Use the "Replace" button (not "Replace All") and click it once. Excel will change the first match and stop. If you want to replace only the second or third occurrence, click "Find Next" to skip ahead, then click "Replace" when you reach the one you want.

Does Find & Replace work on formulas?

Yes, it searches inside formulas too. If you have a formula like =SUM(A1:A10) and you search for "A1", it will find and replace that reference. Be careful — replacing part of a formula can break it. Use "Replace" one at a time to review each change.

Can I use wildcards like * or ? in Find & Replace?

Yes, but only if you enable regular expressions in the options. An asterisk (*) matches any number of characters, and a question mark (?) matches any single character. For example, searching for "cat*" finds "cat", "catalog", and "category". This is advanced and not needed for most replacements.

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

Excel shows a message saying "Search key not found" and does nothing. This is safe — no cells are changed. It just means the word you typed does not appear anywhere in the sheet or range you selected.