Mar 31 2022 02:20 PM
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.
Mar 31 2022 02:56 PM
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.