I'm using Excel as a database, in this example, and not as a spreadsheet. When I open it and do a ''Ctrl + F" naturally, the search window will pop up. I place my search word and it, click on find will then tell me there is not such word. Which I know to be false. I then click behind this search window to the spreadsheet, anywhere and then click on the find button and all of a sudden the word is now findable. So why did it think nothing existed before and now it does? Hence my asking "How exactly does the search function work in Excel?"


Thank you

Interesting question I'd also like to see answered

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

How does one use " Excel as a database and not as a spreadsheet"? Is that relevant to the issue? I have not been able to replicate this with one of my sheets. I open the sheet and the find function works fine.

If you click options, are any of the check boxes checked or is the format clear. I guess that can't be the reason since it works for you immediately thereafter.