Home

Find & Replace, NOT Finding!

%3CLINGO-SUB%20id%3D%22lingo-sub-85812%22%20slang%3D%22en-US%22%3EFind%20%26amp%3B%20Replace%2C%20NOT%20Finding!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-85812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EHello%2C%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EI%20am%20having%20trouble%20finding%20words%20in%20an%20excel%20worksheet.%20I%20tried%20multiple%20options%20with%20the%20Find%20%26amp%3B%20Select%2C%20but%20when%20I%20type%20in%20a%20name%20or%20words%20that%20%3CSTRONG%3EI%20know%3C%2FSTRONG%3E%26nbsp%3Bare%20in%20the%20excel%20sheet%2C%20nothing%20shows%20up.%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EAfter%20scrolling%20through%20the%20excel%20document%20and%20locating%20the%20text%20I%20was%20searching%20for%2C%20I%20will%20match%20it%20exactly%20into%20Find%20%26amp%3B%20Select%20and%20it%20still%20does%20not%20recognize%20it%3F!%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EPlease%20help%2C%20I'm%20on%20a%20deadline%20and%20have%20hundreds%20to%20go%20through!%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-85812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331683%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20%26amp%3B%20Replace%2C%20NOT%20Finding!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331683%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20new%20to%20Excel%2C%20and%20just%20starting%20to%20learn%20it%20in%20my%20business%20computer%20class.%20my%20teacher%20recommends%20this%20site%20to%20try%20their%20downloadable%20practice%20documents%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fedu.gcfglobal.org%2Fen%2Fexcel2013%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fedu.gcfglobal.org%2Fen%2Fexcel2013%3C%2FA%3E%20yet%20whenever%20i%20try%20finding%20something%20i%20know%20is%20there%20like%20a%20website%2C%20i%20get%20an%20error%20in%20find%20and%20replace%20telling%20me%20it%20was%20unable%20to%20find%20what%20i%20was%20looking%20for%2C%20and%20to%20look%20in%20options%2C%20when%20i%20do%20that%2C%20it%20tells%20me%20its%20something%20to%20do%20with%20my%20settings%20for%20Excel%20itself%20that%20i%20have%20no%20idea%20to%20get%20to%2C%20despite%20my%20trust%20settings%20set%20to%20allow%20downloaded%20documents%20to%20be%20edited%20soon%20as%20i%20open%20them.%20here%20is%20the%20pic%20asking%20me%20to%20look%20in%20options%20that%20are%20clearly%20visible%20yet%20at%20the%20same%20time%20unable%20to%20find%20what%20is%20also%20clearly%20there%20i%20would%20like%20to%20replace!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-85823%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20%26amp%3B%20Replace%2C%20NOT%20Finding!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-85823%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Kimberly%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20send%20us%20any%20sample%3C%2FP%3E%3CP%3E-%20create%20new%20workbook%3B%3C%2FP%3E%3CP%3E-%20put%20any%20text%20in%202-3%20cells%3C%2FP%3E%3CP%3E-%20send%20it%20to%20us%20informing%20which%20text%20in%20it%20you%20try%20to%20find%20(if%20that%20doesn't%20work)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-85818%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20%26amp%3B%20Replace%2C%20NOT%20Finding!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-85818%22%20slang%3D%22en-US%22%3E%3CP%3Eyes%20I%20have%20tried%20that%2C%20still%20no%20luck%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-85814%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20%26amp%3B%20Replace%2C%20NOT%20Finding!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-85814%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20the%20text%20a%20%3CU%3Eresult%3C%2FU%3E%20of%20a%20formula%3F%20Then%20klick%20on%20%22Options%22%20and%20change%20%22Look%20in%3A%22%20from%20%22Formulas%22%20to%20%22Values%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20634px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F16977iD553E2084B59D0D6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel-find-replace-select%22%20title%3D%22excel-find-replace-select%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Kimberly Niles
New Contributor

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!

4 Replies

Hi

 

Is the text a result of a formula? Then klick on "Options" and change "Look in:" from "Formulas" to "Values".

excel-find-replace-select

yes I have tried that, still no luck

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

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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies