Open Find and Replace and search for what you want to change

The fastest way to open Find and Replace in Excel is to press Ctrl+H on Windows or Command+H on Mac. A dialog box will appear with two main fields: "Find what" and "Replace with". Type the text, number, or phrase you want to locate in the "Find what" field. This is where you tell Excel what to search for across your spreadsheet.

Excel will search through every cell in your active sheet by default. If you have typed a value into the "Find what" field, you can click "Find All" to see a list of every cell that contains that text before you replace anything. This preview step helps you catch mistakes — for instance, if you search for "John" and it finds "Johnson" too, you will see that before committing to a replacement.

Key Takeaways

  • Press Ctrl+H (Windows) or Command+H (Mac) to open Find and Replace, then type what you want to find and what you want to replace it with.
  • Click "Find All" first to preview every match before you replace anything, which prevents accidental changes to cells you did not intend to modify.
  • Use "Match entire cell contents" if you want to replace only cells that contain exactly that text and nothing else, which stops partial matches.
  • The "Replace All" button changes every match at once, but "Replace" lets you approve each change one at a time if you want more control.
  • You can limit your search to a specific range of cells by selecting them before you open Find and Replace.

Type the replacement text and choose your options

Once you have entered what you are looking for, click in the "Replace with" field and type what you want to put in its place. This can be text, a number, or even nothing at all — leaving it blank will delete the found text. Before you proceed, look at the options below the search fields. The most useful one is "Match entire cell contents", which tells Excel to replace only cells that contain exactly what you typed, nothing more. Without this checked, Excel will replace partial matches too.

For example, if you search for "2024" and replace it with "2025" without "Match entire cell contents" checked, a cell containing "2024-Q1" will become "2025-Q1". If you do check that box, Excel will skip "2024-Q1" because the cell contains more than just "2024". Other useful options include "Match case" (to distinguish between uppercase and lowercase letters) and "Search" (to choose whether to look in formulas, values, or comments).

Preview matches with Find All before replacing

Click the "Find All" button to see a complete list of every cell that matches your search term. Excel will display the results in a window below the dialog box, showing the cell address and the content of each match. This step takes only a moment and can save you from replacing text in the wrong places. If you see a match you did not expect, you can close the dialog, adjust your search term, and try again.

If the list looks correct, you can proceed to replace. You have two choices: "Replace All" will change every match at once, while "Replace" will change one match at a time and let you skip any you want to leave alone. For large spreadsheets or when you are not completely certain about your search term, using "Replace" one at a time gives you more control, even though it takes longer.

Use Replace All for quick changes across the whole sheet

The "Replace All" button is the fastest option when you are confident in your search term and want to change every instance at once. Excel will replace all matches and then show you how many replacements it made. This is useful for tasks like changing a vendor name throughout a budget, updating a product code across an inventory list, or fixing a misspelled word that appears in dozens of cells.

After you click "Replace All", Excel displays a message telling you the number of replacements made. If that number is higher or lower than you expected, you can undo the change when ready by pressing Ctrl+Z. This undo step works even if you have already closed the Find and Replace dialog, so you have a safety net if something goes wrong.

Limit your search to a specific range of cells

If you want to replace text in only part of your spreadsheet, select that range before you open Find and Replace. For instance, if you want to change data only in columns A through C, click on the column header A, hold Shift, and click on column header C to select all three columns. Then press Ctrl+H to open Find and Replace. Excel will search only within your selection, leaving the rest of the sheet untouched.

This approach is helpful when you have similar data in different parts of your spreadsheet and you want to change only one section. You can also select a single cell and search from that point forward, or select multiple non-adjacent ranges by holding Ctrl while clicking. The Find and Replace dialog will respect whatever selection you made before opening it.

Use special characters and wildcards for complex searches

Excel's Find and Replace can search for more than just plain text. If you enable "Regular expressions" in the options (the location varies by Excel version, but it is usually in an "Options" or "More" button), you can use wildcards like .* to match any character or ^ to match the start of a cell. For example, searching for ^[0-9] will find cells that start with a number.

You can also search for line breaks, tabs, and other invisible characters. To find a line break within a cell, type Ctrl+J in the "Find what" field (the character will not be visible, but Excel will register it). This is useful when you have cells with wrapped text and you want to remove or replace those breaks. Regular expressions are more advanced, so start with the basic search options first and move to wildcards only when you need them.

Frequently Asked Questions

Can I undo a Replace All if I made a mistake?

Yes. Press Ctrl+Z when ready after the replacement, and Excel will reverse all the changes. This works even after you close the Find and Replace dialog. If you have made other changes since the replacement, undo will reverse those too, so use it right away if something went wrong.

How do I search in only one column?

Click the column header to select the entire column, then open Find and Replace with Ctrl+H. Excel will search only in that column. You can also select a specific range within a column by clicking the first cell, holding Shift, and clicking the last cell you want to include.

What is the difference between Replace and Replace All?

Replace changes one match at a time and asks you to confirm each one, giving you control over which cells get changed. Replace All changes every match at once without asking. Use Replace when you want to review each change, and Replace All when you are confident and want to save time.

Can I search for a formula instead of text?

Yes, but you need to change the search setting. In the Find and Replace dialog, look for an option that says "Search in" or similar, and choose "Formulas" instead of "Values". This will search the actual formulas in cells rather than the results they display. This is useful if you want to find and replace a specific function or cell reference.

Does Find and Replace work across multiple sheets?

By default, Find and Replace searches only the active sheet. To search all sheets at once, look for an option called "Search" or "Look in" and select "Workbook" instead of "Sheet". This will search every sheet in your file, which is useful for making the same change across multiple tabs.