Find and Replace Function Not Working in Microsoft Excel

Microsoft Excel’s Find and Replace feature is one of the easiest ways to locate specific text, numbers, formulas, or other information and replace it with something else. For example, you can use it to change a company name throughout a worksheet, correct repeated spelling mistakes, replace an old product code, or update numbers in a large spreadsheet.

However, sometimes Find and Replace does not work as expected. Excel may fail to find text that is clearly visible, replace only some results, search the wrong worksheet, or appear to do nothing when you click Replace All. 

This can happen because of search settings, formatting differences, protected sheets, hidden characters, formulas, merged cells, or an incorrect search range.

Let’s fix it!

Find and Replace Function Not Working in Microsoft Excel

If Find and Replace is not working in Microsoft Excel, first check the search options under Find and Replace, especially Within, Search, Look in, and Match case. Then make sure the worksheet is not protected, remove unexpected formatting restrictions, check for hidden spaces or characters, and verify whether you are searching values or formulas. 

If the problem continues, restart Excel, test the workbook in a new file, and repair Microsoft 365 or Office if necessary.

Step 1: Open Find and Replace Correctly

Start by opening the Excel workbook where Find and Replace is not working. Select the worksheet containing the information you want to change.

Press Ctrl + H on your keyboard. This opens the Find and Replace window directly on the Replace tab.

You will see two important fields called Find what and Replace with. Enter the exact text or number you want Excel to locate in Find what. Then enter the new text or number in Replace with.

For example, if your worksheet contains the word January and you want to change it to February, enter January in Find what and February in Replace with.

Click Find Next first instead of immediately selecting Replace All. This helps you confirm that Excel can actually locate the information.

If Excel cannot find something that you can clearly see in the worksheet, continue with the next steps.

Step 2: Check the “Within” Search Setting

One of the most common reasons Find and Replace appears not to work is that Excel is searching the wrong area of the workbook.

In the Find and Replace window, click Options if the additional settings are not already visible.

Look for the Within option. It normally gives you choices such as Sheet and Workbook.

If you are working with several worksheets and want Excel to search all of them, select Workbook. If you only want to search the current worksheet, select Sheet.

For a beginner, a Sheet is usually the easiest option when you know exactly where the information is located.

After changing this setting, click Find Next again. If Excel finds the expected result, you can then use Replace or Replace All.

Step 3: Check the “Look in” Setting

Excel can search different types of content, and the Look in setting can affect your results.

In the expanded Find and Replace window, locate Look in. Depending on your Excel version and the content of your worksheet, you may see options such as Formulas, Values, and Comments or related choices.

If the information you are trying to find is the result displayed by a formula, try changing Look in to Values.

If you are trying to find part of a formula itself, select Formulas.

For example, suppose cell A1 contains a formula such as =B1+C1, while the worksheet displays the result 100. Searching for 100 while looking in formulas may not find the displayed result. Changing the search to Values can help Excel locate what you see on the screen.

Step 4: Turn Off Match Case

The Match case option tells Excel to distinguish between uppercase and lowercase letters.

For example, Excel may treat Excel, EXCEL, and excel differently when Match case is enabled.

Open Find and Replace, select Options, and look for Match case. If it is checked, remove the check mark unless you specifically need a case-sensitive search.

Now try Find Next again.

This simple setting can explain why Excel fails to find text that appears to be identical to what you entered.

Step 5: Check “Match Entire Cell Contents”

Another setting that can prevent Excel from finding an expected result is Match entire cell contents.

When this option is enabled, Excel looks for a cell whose entire content matches your search term.

For example, if a cell contains Microsoft Excel Guide and you search for Excel, Excel may not find it when Match entire cell contents is enabled because the entire cell does not contain only the word “Excel.”

Open Find and Replace, click Options, and make sure Match entire cell contents is unchecked if you want Excel to find your search term inside longer cell contents.

Then run the search again.

Step 6: Remove Unwanted Formatting From the Search

Sometimes Find and Replace appears to be broken because the search is restricted by formatting.

In the Find and Replace window, click Options. Look for the Format button next to the search fields.

If a particular format has been selected, Excel may only search for cells that match that formatting.

To remove the formatting condition, click the small drop-down next to Format and select Clear Find Format, if that option is available in your Excel version.

Then try the search again.

This is particularly important if someone previously used Find and Replace with a specific font, fill color, number format, or other formatting condition.

Step 7: Check for Extra Spaces or Hidden Characters

If Excel still cannot find the text, the cell may contain extra spaces or other characters that are not immediately visible.

For example, the cell might contain:

Windows 11

instead of:

Windows 11

The extra space at the end can cause your search to behave differently, especially when you are using exact matching.

You can click the cell and look at its contents in the Formula Bar above the worksheet. Carefully check whether there are unexpected spaces before or after the text.

For larger datasets, Excel functions such as TRIM can help remove unnecessary spaces. You can also copy a known value directly from the worksheet and paste it into the Find what box. This reduces the possibility of making a typing mistake.

Step 8: Check Whether the Worksheet Is Protected

A protected worksheet can restrict what you are able to change.

Go to the Review tab on the Excel ribbon and look for Protect Sheet or Unprotect Sheet.

If the worksheet is protected, you may need to select Unprotect Sheet before making certain changes. If Excel asks for a password, you will need the password set by the person who protected the worksheet.

After the sheet is unprotected, open Find and Replace again and test Replace.

If you are working with a spreadsheet created by someone else, do not try to bypass a protection password. Ask the workbook owner for permission or the appropriate password.

Step 9: Check Whether You Selected Only Part of the Worksheet

Excel can limit Find and Replace to a selected range.

For example, suppose your worksheet contains the word Printer in cells A1:A100 and another occurrence in D1:D100. If you select only A1:A100 before starting Find and Replace, Excel may search only that selected area depending on the operation and Excel version.

Press Esc or click a single cell to remove an accidental large selection.

Then press Ctrl + H and try the search again.

If you intentionally want to replace information in only one area, selecting that range can be useful. Otherwise, make sure you are not accidentally restricting the search.

Step 10: Check Whether You Are Searching Formulas Instead of Results

This problem is especially common with spreadsheets that contain many formulas.

Imagine a cell displays 500, but the actual cell contains a formula such as =SUM(B2:B10). If you search for 500 while Excel is looking at Formulas, Excel may not find it because 500 is the calculated result rather than the formula itself.

Open Find and Replace, select Options, and check the Look in setting.

Choose Values when you want to search the results displayed in cells. Choose Formulas when you need to find text or references inside formulas.

Understanding this difference can make Find and Replace much easier to use.

Step 11: Try Replace Instead of Replace All

If Replace All does not appear to work correctly, test one result at a time.

Enter your search term and replacement text, then click Find Next. If Excel finds the correct cell, click Replace.

Continue using Find Next and Replace to see whether individual replacements work.

If individual replacements work but Replace All does not produce the expected result, carefully review your search settings, selected range, formatting restrictions, and workbook structure.

Using Replace first is also safer when you are making an important change because you can verify each result before modifying the entire worksheet.

Step 12: Restart Excel and Test the Workbook Again

If all the settings appear correct, save your workbook and close Excel completely.

Open Excel again and reopen the workbook. Press Ctrl + H and test Find and Replace.

Temporary application problems can sometimes cause Excel features to behave unexpectedly. Restarting Excel is a simple troubleshooting step that can eliminate these temporary issues.

You can also test the feature in a new blank workbook. Type a few sample words into several cells and use Find and Replace.

If Find and Replace works normally in the new workbook but not in your original file, the issue may be related to that particular workbook rather than Excel itself.

Step 13: Repair Microsoft Excel or Microsoft 365

If Find and Replace does not work in multiple workbooks, the problem may involve your Microsoft Office or Microsoft 365 installation.

On Windows, open Settings and go to Apps > Installed apps. Find Microsoft 365 or your installed version of Microsoft Office.

Select the available options for the installation and look for Modify or Change, depending on your version of Windows and Office.

Microsoft provides repair options that can fix damaged Office components. Start with Quick Repair when available. If that does not solve the problem, you can consider Online Repair, which is a more comprehensive repair process and may require an internet connection.

After the repair finishes, restart your computer and test Find and Replace again.

FAQs

Why is Excel Find and Replace not finding text?

The most common causes include incorrect Look in, Within, or Match case settings. Formatting restrictions, extra spaces, hidden characters, and formulas can also affect search results.

Why does Excel Find work but Replace does not?

If Excel can find the information but cannot replace it, check whether the worksheet is protected or whether the selected cells are restricted. Also, check whether you are trying to replace formula results rather than the formulas themselves.

Why does Replace All not replace everything in Excel?

Check whether Excel is searching only the current sheet, whether a specific range is selected, whether Match entire cell contents is enabled, or whether a Find Format condition has been applied.

Why can’t Excel find a word that is clearly visible?

The visible text may be produced by a formula, contain extra spaces, or have different capitalization. Check Look in, turn off Match case, and try copying the visible text directly into the Find what field.

How do I search the entire Excel workbook?

Press Ctrl + H, click Options, and change Within from Sheet to Workbook. Excel can then search across the worksheets in the workbook.

Can protected Excel sheets prevent Find and Replace?

Worksheet protection can restrict changes to cells. If replacement is not allowed, check the Review tab and determine whether the worksheet is protected. If it is protected with a password, contact the workbook owner if you need editing access.

Summary

When the Find and Replace function is not working in Microsoft Excel, begin by checking Within, Look in, Match case, and Match entire cell contents. Next, remove any unwanted Find Format settings, check for extra spaces, confirm that the worksheet is not protected, and make sure you are searching the correct range. 

If the problem continues, restart Excel, test another workbook, and repair your Microsoft 365 or Office installation. In most cases, one of these checks will restore Find and Replace without requiring advanced troubleshooting.