Excel update Ctr F not showing replace button

%3CLINGO-SUB%20id%3D%22lingo-sub-1435222%22%20slang%3D%22en-US%22%3EExcel%20update%20Ctr%20F%20not%20showing%20replace%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435222%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20an%20issue%20with%20MS%20Excel.%20The%20first%20issue%20is%20that%20when%20I%20use%20the%20Find%20and%20replace%20functionality%20the%20%22replace%22%20and%20%22replace%20all%22%20buttons%20are%20disappearing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20second%20issue%20is%20that%20I%20ask%20it%20to%20find%20certain%20text%2C%20the%20text%20is%20there%20but%20it%20says%20it%20cannot%20find%20anything%20matching%20my%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20restart%20excel%20a%20lot%20but%20the%20above%20issue%20is%20consistently%20there%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1435222%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435883%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20update%20Ctr%20F%20not%20showing%20replace%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687365%22%20target%3D%22_blank%22%3E%40Connieb1974%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20Replace%20problem%20you%20should%20consider%20using%20Ctrl%20%2B%20H%20to%20replace.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20second%20issue%2C%20play%20around%20with%20the%20%3CSTRONG%3EOptions%26gt%3B%26gt%3B%26nbsp%3B%3C%2FSTRONG%3Eto%20ensure%20you%20are%20searching%20within%20the%20right%20Sheet%20and%20other%20options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELastly%2C%20have%20only%20the%20excel%20workbook%20are%20wanting%20to%20search%20open%20so%2C%20your%20search%20is%20not%20getting%20applied%20to%20the%20wrong%20open%20excel%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi All

 

I am having an issue with MS Excel. The first issue is that when I use the Find and replace functionality the "replace" and "replace all" buttons are disappearing.

 

The second issue is that I ask it to find certain text, the text is there but it says it cannot find anything matching my text.

 

I have to restart excel a lot but the above issue is consistently there

1 Reply
Highlighted

@Connieb1974 

 

For the Replace problem you should consider using Ctrl + H to replace.

 

For the second issue, play around with the Options>> to ensure you are searching within the right Sheet and other options.

 

Lastly, have only the excel workbook are wanting to search open so, your search is not getting applied to the wrong open excel workbook.