SOLVED
Home

Office 365 Excel 2016 - Find and replace window

%3CLINGO-SUB%20id%3D%22lingo-sub-896334%22%20slang%3D%22en-US%22%3EOffice%20365%20Excel%202016%20-%20Find%20and%20replace%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896334%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20might%20be%20picky%20but%20in%202010%20version%2C%20the%20Find%20and%20Replace%20window%20was%20much%20better%20developed.%20With%202016%20version%20it%20seems%20to%20be%20%22always%20on%20top%22%20and%20I%20could%20not%20find%20any%20option%20to%20turn%20it%20off%20so%20it%20can%20disappear%20as%20soon%20as%20i%20click%20on%20the%20spreadsheet.%3C%2FP%3E%3CP%3EAlso%20it%20seems%20the%20text%20that%20is%20already%20there%2C%20it%20does%20not%20highlight%20at%20each%20call%20of%20the%20window.%3C%2FP%3E%3CP%3EI%20do%20a%20lot%20of%20work%20in%20cross%20checking%20and%20replacing%20and%20it%20is%20proper%20annoying%20but%20as%20its%20company%20decision%20I%20cant%20go%20back%20to%20older(in%20my%20opinion%20better)%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20fix%3F%20Why%20would%20always%20on%20top%20become%20a%20standard%20when%20the%20shortcut%20for%20it%20is%20very%20simple%20and%20convinient%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EJakub%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-896334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efind%20and%20replace%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901295%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%202016%20-%20Find%20and%20replace%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901295%22%20slang%3D%22en-US%22%3Ethe%20keyboard%20shortcut%20ctrl%2Bh%20opens%20the%20search%20and%20replace%20pop%20up.%20whenever%20you%20want%20to%20close%20it%20you%20could%20do%20a%20ctrl%2Bh%20and%20then%20press%20esc%3CBR%20%2F%3EDoes%20that%20work%20for%20you%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901400%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%202016%20-%20Find%20and%20replace%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-%20it%20is%20actually%20good%20solution%20(%20not%20sure%20why%20i%20did%20not%20think%20of%20it).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20there%20is%20no%20way%20of%20making%20it%20work%20like%20it%20was%20in%202010%20version%20of%20the%20program%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901407%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%202016%20-%20Find%20and%20replace%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901407%22%20slang%3D%22en-US%22%3EI'm%20glad%20this%20works%20for%20you%3CBR%20%2F%3ETo%20be%20honest%20i%20don't%20remember%20how%20it%20was%20in%20the%202010%20version%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-901412%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%202016%20-%20Find%20and%20replace%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901412%22%20slang%3D%22en-US%22%3EFair%20play%20-%20thanks%20for%20helping%20!%3C%2FLINGO-BODY%3E
jk_88
New Contributor

Hi,

I might be picky but in 2010 version, the Find and Replace window was much better developed. With 2016 version it seems to be "always on top" and I could not find any option to turn it off so it can disappear as soon as i click on the spreadsheet.

Also it seems the text that is already there, it does not highlight at each call of the window.

I do a lot of work in cross checking and replacing and it is proper annoying but as its company decision I cant go back to older(in my opinion better) version.

 

Is there any fix? Why would always on top become a standard when the shortcut for it is very simple and convinient?

 

Regards

Jakub

4 Replies
Solution
the keyboard shortcut ctrl+h opens the search and replace pop up. whenever you want to close it you could do a ctrl+h and then press esc
Does that work for you?

@PascalKTeam 

Thanks - it is actually good solution ( not sure why i did not think of it).

 

So there is no way of making it work like it was in 2010 version of the program?

I'm glad this works for you
To be honest i don't remember how it was in the 2010 version
Fair play - thanks for helping !
Related Conversations
Break or Pause during Replace command
Quality2663 in Excel AMA on
5 Replies
Dont see any Contact in Teams
nicb in Microsoft Teams on
2 Replies
Exchange 2016/2019 Download link
Robin Nishad in Exchange on
7 Replies
No setting default margins?
listondavis in Excel on
5 Replies