Jan 10 2019 06:09 AM - edited Jan 10 2019 06:19 AM
I have a huge excel sheet with a lot of simpleformulas. now i want to give all cells a name so the formula should be easy to understand.
I want to convert my formula for example, D4: "=D2*D3" to (when i named D2: "name1" and D3: "name2") D4: "=name1*name2".
When i have to do this manualyfor all formulas i need a few years.
Thanks in advanced!
Jan 10 2019 06:41 AM
Jan 10 2019 07:27 AM
thanks for the quick reply, this works not as I hoped. can not just select the cell and apply names. then i get an error. for no names found.
Jan 10 2019 08:48 AM
You have to define names first (e.g. Name1 for D2, etc) and after that apply defined names to the formulas
May 15 2019 11:13 AM
I cannot get apply names to work. I get an error popup window that says: "Microsoft Excel cannot find any references to replace. The formula that contains that cell reference that I want to replace consists of the following: =B165*('Cover Page Major Assumptions'!$B$26)*-1
I am trying to replace the reference to B26 with the named range Total_Income_Tax_Rate. B26 is actually located on a separate sheet - and the scope of the name is "workbook". I cannot get "Apply Names" to work!! It is very frustrating.
May 16 2019 09:59 AM
May 16 2019 10:10 AM
Thank you. I appreciate your help.
Another person suggested using Find and Replace which I think will work fine and won't be hard to do.
It's funny - I use Find and Replace all the time and never for one second considered it for this problem. Sometimes the solutions are so simple - yet not obvious when you get fixated on doing it a certain way. My fixation on Apply Names prevented me from thinking it through clearly.