Jul 08 2017 08:49 AM
Hello,
I am having trouble finding words in an excel worksheet. I tried multiple options with the Find & Select, but when I type in a name or words that I know are in the excel sheet, nothing shows up.
After scrolling through the excel document and locating the text I was searching for, I will match it exactly into Find & Select and it still does not recognize it?!
Please help, I'm on a deadline and have hundreds to go through!
Jul 08 2017 09:24 AM
Hi
Is the text a result of a formula? Then klick on "Options" and change "Look in:" from "Formulas" to "Values".
Jul 08 2017 10:22 AM
Hi Kimberly,
Could you please send us any sample
- create new workbook;
- put any text in 2-3 cells
- send it to us informing which text in it you try to find (if that doesn't work)
Thanks
Feb 06 2019 06:53 AM - edited Feb 06 2019 06:54 AM
i am new to Excel, and just starting to learn it in my business computer class. my teacher recommends this site to try their downloadable practice documents https://edu.gcfglobal.org/en/excel2013 yet whenever i try finding something i know is there like a website, i get an error in find and replace telling me it was unable to find what i was looking for, and to look in options, when i do that, it tells me its something to do with my settings for Excel itself that i have no idea to get to, despite my trust settings set to allow downloaded documents to be edited soon as i open them. here is the pic asking me to look in options that are clearly visible yet at the same time unable to find what is also clearly there i would like to replace!