Find and Replace window disappears after search

%3CLINGO-SUB%20id%3D%22lingo-sub-1587041%22%20slang%3D%22en-US%22%3EFind%20and%20Replace%20window%20disappears%20after%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587041%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3Ei'm%20having%20a%20weird%20problem%20with%20an%20Excel%20%22Find%20and%20Replace%22%20function.%3CBR%20%2F%3EIt%20goes%20away%20after%20I%20perform%20Find%20All%20or%20Find%20Next.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EFor%20example%3A%20i%20performed%20a%20search%20and%20it'd%20say%20%22we%20couldn't%20find%20what%20you're%20looking%20for...%22%20%26gt%3B%26gt%3B%20so%20i%20hit%20OK%20and%20%22Find%20and%20Replace%22%20would%20still%20be%20there%20so%20I%20could%20do%20another%20search.%20But%20now%20it's%20gone%20after%20I%20click%20OK...%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20advise.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1587041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587325%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20window%20disappears%20after%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587325%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758655%22%20target%3D%22_blank%22%3E%40ian1050%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20on%20Cltr%20%2B%20H%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587373%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20window%20disappears%20after%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3Bthanks%20for%20suggestion%20but%20that's%20not%20related%20to%20my%20question.%20i%20need%20this%26nbsp%3BFind%20and%20Replace%20%3CU%3E%3CSTRONG%3Ewindow%3C%2FSTRONG%3E%3C%2FU%3E%20to%20be%20stayed%20on%20the%20screen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20other%20thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587400%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20window%20disappears%20after%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F758655%22%20target%3D%22_blank%22%3E%40ian1050%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20get%20your%20point%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20happen%20on%20all%20files%20or%20is%20it%20only%20on%20specific%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587639%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20window%20disappears%20after%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3Eit%20happens%20to%20one%20file%20only.%20what's%20interesting%20is%20that%20no-one%20using%20this%20file%20has%20this%20issue.%20i%20even%20tried%20to%20copy%20paste%20the%20content%20of%20the%20file%20to%20a%20new%20book%20-%20same%20result%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,
i'm having a weird problem with an Excel "Find and Replace" function.
It goes away after I perform Find All or Find Next.

For example: i performed a search and it'd say "we couldn't find what you're looking for..." >> so i hit OK and "Find and Replace" would still be there so I could do another search. But now it's gone after I click OK...

Please advise. Thank you

4 Replies

Hi @ian1050 

 

Click on Cltr + H again.

 

Cheers

@wumolad thanks for suggestion but that's not related to my question. i need this Find and Replace window to be stayed on the screen.

 

any other thoughts?

@ian1050 

 

I get your point now.

 

Does this happen on all files or is it only on specific file?

@wumolad 
it happens to one file only. what's interesting is that no-one using this file has this issue. i even tried to copy paste the content of the file to a new book - same result