Excel FIND not working

If you are using the Find function in Excel (CTRL F or else in the HOME ribbon under Find & Select) you may get frustrated when it appears that the Excel find is not working. This could be for a number of reasons but in this case we are assuming that you know it is there and can see it yourself.

You have highlighted more than 2 cells but looking for other cells

The Find tool will only look through all the cells in a sheet if you are clicked on only 1 cell. If you have highlighted 2 or more cells, it will then only look only in those cells for the item.

You are searching in formula and not values

In the example below, you will note that our website address appears in full in the cell (column F) but in the formula bar it is a formula which builds up the address.

If we tried to find the word AuditExcel using the default settings it would say it couldn’t find it. This is because by default the Find looks IN the formula and not the result in the cell. So in the formula there is nothing that says AuditExcel, but rather “Audit”,”Excel”.

Excel find not working

If the FIND in Excel is not working when you want to find the word AuditExcel you must not look at the formula but rather the result (values) in the cell. To do this you would need to change the ‘Look In’ setting to Values. Notice as well that you can also use this if you are searching for some words in comments.

REMOVE current selection from data filter

Find all the Excel functions prone to spreadsheet errors

How to find cells with external links in Excel