The fastest way to replace one word with another across your spreadsheet
Open the Find & Replace dialog by pressing Ctrl+H on Windows or Cmd+Option+F on Mac. Type the word you want to find in the "Find what" field and the replacement word in the "Replace with" field, then click "Replace All" to change every instance at once. If you want to be more careful and review each change before it happens, click "Replace" one at a time instead.
The dialog stays open after you finish, so you can search for another word without closing it. When you are done, press Escape or click the X button to close it.
Key Takeaways
- Press Ctrl+H (Windows) or Cmd+Option+F (Mac) to open Find & Replace without using the menu.
- Type the word to find and the replacement word, then click "Replace All" to change every instance in seconds.
- Click "Replace" one at a time if you want to see each match before it changes, which is safer when you are unsure about the scope.
- Use "Match entire cell contents" if you want to replace only cells that contain exactly that word and nothing else.
- The "Options" button reveals settings like "Match case" to distinguish between uppercase and lowercase versions of the same word.
Step-by-step: replacing a single word everywhere
Open your spreadsheet and press Ctrl+H (Windows) or Cmd+Option+F (Mac). The Find & Replace dialog appears.
In the "Find what" field, type the word you want to replace. In the "Replace with" field, type the new word. Click "Replace All" and Excel will change every match in the entire sheet at once. A message tells you how many replacements were made.
If you are not sure whether every match should be replaced — for example, if the word appears as part of other words — use "Replace" instead. Excel highlights each match one at a time, and you decide whether to replace it or skip it by clicking "Replace" or "Find Next".
Controlling what gets replaced: options that matter
Click the "Options" button in the Find & Replace dialog to see more settings. Match case tells Excel to treat uppercase and lowercase as different — so searching for "Smith" will not match "smith". This is useful when you need to preserve capitalization rules.
Match entire cell contents replaces only cells that contain exactly that word and nothing else. Without this option, Excel replaces the word even if it is part of a longer word or phrase. For example, searching for "cat" without this option will change "catalog" to "doalog" if you replace it with "dog" — usually not what you want.
The Search dropdown lets you choose whether to search by rows or by columns, though this rarely matters for a straightforward replacement. Leave it on the default unless you have a specific reason to change it.
Replacing only in a specific part of your spreadsheet
If you want to replace a word only in certain cells, select those cells first before opening Find & Replace. Excel will search only within your selection. This is the safest way to make changes when you are worried about replacing something you did not intend to touch.
To select a range, click the first cell, hold Shift, and click the last cell. Or click a column header to select the entire column. Then press Ctrl+H and make your replacements — they will affect only what you selected.
Undoing a replacement you did not mean to make
If you click "Replace All" and realize the change was wrong, press Ctrl+Z when ready to undo. Excel will reverse all the replacements at once. This works even if you made hundreds of changes.
This is why using "Replace" one at a time is safer when you are uncertain — you catch mistakes as they happen instead of discovering them after the fact. But if you do make a mistake with "Replace All", undo is your friend.
When Find & Replace gets confused: special characters and formulas
If you are searching for a word that contains a special character — like a dollar sign, asterisk, or question mark — you may need to put a backslash before it so Excel knows you mean the character itself, not a wildcard. For example, to find "$100", type "\$100" in the Find field. This is rare in everyday use, but it matters if your data contains these symbols.
Find & Replace searches the text you see in cells, not the formulas behind them. If a cell displays "Total" because a formula calculated it, you cannot find "Total" with Find & Replace — you would need to find the formula itself. For most word replacements in regular data, this is not a problem.
Replacing across multiple sheets at once
By default, Find & Replace works on only the sheet you are currently viewing. If you need to replace a word across all sheets in your workbook, click "Options" and look for a dropdown that says "Sheet" or "Workbook". Change it to "Workbook" and your replacement will affect every sheet.
Be very careful with this option — it is straightforward to make changes you did not intend when you are working across multiple sheets at once. If you are new to this, replace one sheet at a time instead.
Frequently Asked Questions
Can I replace a word only in cells that contain other specific text?
Find & Replace does not have a built-in "and" condition, but you can work around it by selecting the cells you want first, then opening Find & Replace. It will search only within your selection, so you can narrow down where the replacement happens.
What if I want to replace a word but keep some letters capitalized?
Find & Replace does not automatically preserve capitalization patterns. If you need "Smith" to become "Johnson" and "smith" to become "johnson", you have to do two separate replacements — one with "Match case" on for each version. This is tedious but necessary if your data mixes cases.
Does Find & Replace work the same way in Google Sheets?
Google Sheets has a similar Find & Replace tool (Ctrl+H or Cmd+H), but the options are slightly different. The basic find and replace all function works the same way, but some advanced options like "Match entire cell contents" are in different places or named differently.
Can I undo a replacement if I closed the file without saving?
No. Once you close the file without saving, the undo history is gone. Always save your work before making large replacements, or save a backup copy first so you have something to go back to if something goes wrong.
What happens if I search for a blank cell?
Leave the "Find what" field empty and click "Replace All" to replace all blank cells with whatever you put in "Replace with". This is useful if you need to fill empty cells with a default value, but be careful — it affects every empty cell in your selection or sheet.