This tutorial demonstrates some fixes for when Find & Replace is not working in Excel.
Common Issues and Fixes for Find Errors
In Excel, the Find & Replace feature makes the searching process faster and easier when you want to find specific information in a worksheet. But sometimes this feature can stop working.
Searching Nonexistent Text
The most common reason for the error is that the string you’re searching doesn’t exist. Say you have a data set with prices in Columns A, B, and C.
If you enter text that doesn’t exist in the workbook in the Find what box and click Find All, Excel will open an error message.
It’s normal to get the error message above if you search for nonexistent text. But if you try to find and replace a text string that does exist in the workbook and you still get this error message, try the following solutions.
Using Replace All Without Find All
If you forget to click the Find All or Find Next option before clicking the Replace All or Replace option, it will cause the error message: “Microsoft Excel cannot find a match.”
To fix this mistake, first click the Find All (or Find Next) button, and then press the Replace All (or Replace).
Wrong Cell Selection
If it’s only one cell selected, Excel will go through the entire cells of the worksheet.
If more than one cell is selected, then the find option from the Find & Replace feature will only be applied to those cells.
So, to fix this problem check if you made the right cell selection or just select one cell in order to apply the find option to the entire workbook.
Another possible reason why Find doesn’t work is that your sheet is protected. In a protected sheet, you can find text, but you won’t be able to make any changes with Replace.
To fix this problem, in the Ribbon, go to Review and click on Unprotect Sheet icon.
In the dialog box, enter the password to unlock it.
As a result, you should be able to use the Find & Replace feature on your worksheet.
Corrupted Excel Worksheet
Sometimes the Find & Replace feature won’t work because the data you are looking for is actually missing from the worksheet due to Excel file corruption. In this case, the best thing you can do is to repair the file using the Restore function.