SOLVED
Home

Find and Replace "Find what" pull-down

%3CLINGO-SUB%20id%3D%22lingo-sub-905635%22%20slang%3D%22en-US%22%3EFind%20and%20Replace%20%22Find%20what%22%20pull-down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905635%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20use%20find%20and%20replace%20I%20often%20need%20to%20enter%20the%20same%20text%20that%20I%20had%20previously%20found%20and%20replaced.%20There%20is%20a%20pull%20down%20which%20has%20the%20intent%20of%20storing%20previous%20searches.%20However%2C%20when%20I%20select%20the%20pull-down%20it%20is%20always%20blank.%20It%20never%20seems%20to%20remember%20my%20previous%20searches.%20Am%20I%20doing%20something%20wrong%20or%20does%20it%20just%20not%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-905635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905744%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20%22Find%20what%22%20pull-down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396954%22%20target%3D%22_blank%22%3E%40GreatNo%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EExcel%20should%20remember%20your%20recent%20searches%20as%20long%20as%20Excel%20is%20still%20open.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EIf%20you%20quit%20Excel%20and%20open%20the%20workbook%20again%2C%20your%20recent%20searches%20will%20be%20erased!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ERegards%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905966%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20%22Find%20what%22%20pull-down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3EIt%20is%20not%20working%20that%20way.%20I%20have%20attached%20a%20video%20showing%20my%20problem.%20When%20I%20do%20the%20last%20Find%20and%20Replace%2C%20I%20expect%20%22%24N%22%20to%20be%20in%20the%20pull-down%20because%20I%20had%20previously%20searched%20for%20it.%20However%2C%20it%20is%20not%20there%20and%20I%20have%20to%20type%20it%20in%20again.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-906079%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20%22Find%20what%22%20pull-down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-906079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396954%22%20target%3D%22_blank%22%3E%40GreatNo%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Replace%20doesn't%20save%20the%20recent%20searches%20in%20the%20%3CSTRONG%3EFind%20what%3C%2FSTRONG%3E%20dropdown%20list!%3C%2FP%3E%3CP%3EBut%20you%20can%20save%20it%20in%20the%20dropdown%20list%20by%20selecting%20%3CSTRONG%3EFind%20All%3C%2FSTRONG%3E%20before%20you%20select%20%3CSTRONG%3EReplace%20All%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EThis%20is%20the%20trick%20you%20need!%20but%20it%20costs%20you%20an%20extra%20click!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-906187%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20%22Find%20what%22%20pull-down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-906187%22%20slang%3D%22en-US%22%3EI%20guess%20I%20can%20live%20with%20that.%20Thanks!%3C%2FLINGO-BODY%3E
GreatNo
New Contributor

When I use find and replace I often need to enter the same text that I had previously found and replaced. There is a pull down which has the intent of storing previous searches. However, when I select the pull-down it is always blank. It never seems to remember my previous searches. Am I doing something wrong or does it just not work?

4 Replies

@GreatNo

 

Hi,

 

Excel should remember your recent searches as long as Excel is still open. If you quit Excel and open the workbook again, your recent searches will be erased!

 

Regards

 

@Haytham AmairahIt is not working that way. I have attached a video showing my problem. When I do the last Find and Replace, I expect "$N" to be in the pull-down because I had previously searched for it. However, it is not there and I have to type it in again. 

Solution

@GreatNo

 

The Replace doesn't save the recent searches in the Find what dropdown list!

But you can save it in the dropdown list by selecting Find All before you select Replace All.

This is the trick you need! but it costs you an extra click!

 

Hope that helps

I guess I can live with that. Thanks!
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