The Find and Replace tool does the work for you

Excel's Find and Replace feature lets you swap one word or phrase for another across your entire spreadsheet in seconds. Instead of clicking through each cell to edit by hand, you tell Excel what to find and what to put in its place, and it handles the rest. You can replace one instance at a time or all of them at once.

This is most useful when you have made a mistake that repeats across many rows — a misspelled product name, an outdated department title, or a wrong date format. It also works when you need to clean up data someone else entered inconsistently, like "NY" in some cells and "New York" in others.

Key Takeaways

  • Open Find and Replace by pressing Ctrl+H on Windows or Command+H on Mac, or by going to the Home tab and clicking Find and Replace.
  • Type the text you want to find in the first box and the replacement text in the second box, then choose Replace All to change every instance at once.
  • Use the Options button to search only in specific columns, match whole words only, or search by cell formatting rather than text.
  • Replace All makes changes when ready across your entire sheet, so review your search terms carefully before clicking to avoid unintended replacements.
  • You can undo any replacement by pressing Ctrl+Z when ready after if you realize the change was wrong.

Opening Find and Replace

The fastest way to open Find and Replace is to press Ctrl+H on Windows or Command+H on Mac. A dialog box will appear with two text fields: one labeled "Find what" and one labeled "Replace with."

If you prefer using the menu, click the Home tab at the top of your spreadsheet. In the ribbon, look for the Find and Replace button — it is usually in the far right section of the Home tab, inside a group labeled "Editing." Click the small arrow next to it and select "Replace" from the dropdown.

Entering your search and replacement text

In the "Find what" field, type the exact text you want to locate. If you are replacing "Manager" with "Team Lead," type "Manager" in the first box. In the "Replace with" field, type "Team Lead."

Excel is case-sensitive by default, which means it will treat "manager" and "Manager" as different text. If you want to find both versions no matter how they are capitalized, click the Options button to expand the dialog, then uncheck the box labeled "Match case."

Once both fields are filled, you have two choices: click Replace All to change every instance in your spreadsheet at once, or click Replace to change one at a time. Replace All is faster when you are confident the search term is correct. Replace is safer when you want to review each change before it happens.

Using Options to narrow your search

Click the Options button in the Find and Replace dialog to see additional controls. These let you be more precise about what Excel searches for and where it searches.

The Match entire cell contents checkbox is useful when you want to find cells that contain only your search term and nothing else. For example, if you search for "CA" without this box checked, Excel will also find and replace "CA" inside "CALIFORNIA" or "CANADA." With the box checked, it will only replace cells that say exactly "CA."

The Search dropdown lets you choose whether to search by rows or by columns. The Within dropdown lets you limit the search to the current sheet or expand it to all sheets in your workbook. If you have selected a range of cells before opening Find and Replace, you can check Search in and choose to search only within that selection.

Replacing one instance at a time

If you want to review each replacement before it happens, use the Replace button instead of Replace All. Excel will highlight the first cell that matches your search term and stop. You can then click Replace to change that one cell, or click Find Next to skip it and move to the next match without changing anything.

This approach takes longer but is safer when you are unsure whether every instance of your search term should be replaced. For example, if you search for "2024" to replace it with "2025," you might find that some dates should stay as 2024 because they refer to historical data. Reviewing each one lets you make that decision cell by cell.

Undoing a replacement you did not mean to make

If you click Replace All and then realize the change was wrong, press Ctrl+Z on Windows or Command+Z on Mac when ready. This will undo the entire replacement and restore your spreadsheet to the way it was before.

Undo works best when you catch the mistake right away. If you have made other changes to your spreadsheet since the replacement, pressing Ctrl+Z will undo those changes too, so be aware of what else you have done. If you are not sure whether a replacement was correct, close the file without saving and reopen it to start over.

Common mistakes to avoid

The most common mistake is forgetting that Find and Replace searches your entire spreadsheet by default. If you have multiple sheets and only want to change one, make sure you are on the correct sheet before you open Find and Replace. You can also use the Within option to limit the search to the current sheet only.

Another mistake is using Replace All when your search term is too short or too common. For example, searching for "a" and replacing it with "the" will change every cell containing the letter "a," which is almost certainly not what you want. Always use the Match entire cell contents option when you are searching for short words or abbreviations, or use Replace instead of Replace All so you can see each match before it changes.

Be careful with spaces and special characters. If you search for "New York" but some cells have "New York" with two spaces, Excel will not find those cells unless you search for the exact spacing. If you are not sure about spacing, you can use a wildcard — click Options and check Use regular expressions, then use a period (.) to represent any single character or an asterisk (*) to represent any number of characters.

Frequently Asked Questions

Can I search for text in only one column instead of the whole spreadsheet?

Yes. Click on the column header to select the entire column, then open Find and Replace. The search will be limited to that column only. You can also select a specific range of cells before opening Find and Replace, and the search will stay within that range.

What if I want to replace text but keep some of the original text?

Use the replacement field to include the text you want to keep. For example, if you want to change "John Smith" to "Smith, John," search for "John Smith" and replace it with "Smith, John." If you need more control, consider using a formula instead of Find and Replace.

Does Find and Replace work on formulas or only on the text I see?

Find and Replace searches both the text displayed in cells and the formulas behind them. If you have a formula that references a cell named "OldName" and you search for "OldName," it will find and replace that text inside the formula too. Be careful when replacing text in formulas, as changing the wrong part can break your calculations.

Can I replace text with nothing to delete it?

Yes. Leave the "Replace with" field empty and click Replace All. This will remove every instance of your search term from the spreadsheet. This is useful for cleaning up extra spaces or removing a prefix that appears in many cells.

What does the Find All button do?

Find All shows you a list of every cell that contains your search term, without making any changes. This is helpful when you want to see how many instances exist before you decide whether to replace them. Click on any result in the list to jump to that cell in your spreadsheet.