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 ...
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.