Forum Discussion
Searching excel using Find
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.
