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