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
Tabs and Dark Mode
cjc2112 in Discussions on
21 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
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies