Searching excel using Find

Occasional Visitor

When I am searching for data in my spreadsheet the find button is telling me that the data can't be found. I know it is there and I have used this before. What do I need to do to find information on my spreadsheet again? I have not changed anything and this function was working until a few days ago. 

please help me get this corrected.  

1 Reply


Click Options>> in the Find dialog.

Inspect the various options - perhaps 'Match case' or 'Match entire cell contents' has been ticked, or a format has been specified, or you're searching formulas instead of values.