Home

Cell Reference to Named Reference

%3CLINGO-SUB%20id%3D%22lingo-sub-905069%22%20slang%3D%22en-US%22%3ECell%20Reference%20to%20Named%20Reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905069%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20defined%20lot%20of%20named%20ranges%20recently%20in%20an%20already%20built%20financial%20model%20for%20ease%20of%20review.%20Is%20there%20a%20way%20to%20replace%20all%20such%20ranges%20in%20one%20go%20instead%20of%20doing%20the%20%22Find%20%26amp%3B%20Replace%22%20activity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20one%20way%20explained%20in%20another%20blog%20was%20to%20use%20%22Apply%20Names%22%20which%20seemed%20like%20THE%20Solution%20but%20apperently%20its%20not%20working.%20the%20error%20says%3A%20%22Microsoft%20Excel%20cannot%20find%20any%20reference%20to%20replace%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-905069%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-905719%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Reference%20to%20Named%20Reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423594%22%20target%3D%22_blank%22%3E%40Moiz_Ali%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20execute%20this%20procedures%3A%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Highlight%20the%20range%20in%20which%20you%20wish%20to%20apply%20names%3B%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Press%20Alt%2CM%2CM%2CA%3B%26nbsp%3B%3C%2FP%3E%3CP%3E3%3A%20Hightlight%20the%20names%20you%20wish%20to%20apply%3B%20and%26nbsp%3B%3C%2FP%3E%3CP%3E4.%20Click%20OK.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Moiz_Ali
Occasional Visitor

Hi all,

 

I have defined lot of named ranges recently in an already built financial model for ease of review. Is there a way to replace all such ranges in one go instead of doing the "Find & Replace" activity.

 

The one way explained in another blog was to use "Apply Names" which seemed like THE Solution but apperently its not working. the error says: "Microsoft Excel cannot find any reference to replace".

 

1 Reply

@Moiz_Ali 

Please execute this procedures: 

1. Highlight the range in which you wish to apply names; 

2. Press Alt,M,M,A; 

3: Hightlight the names you wish to apply; and 

4. Click OK. 

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