Forum Discussion

Niels07's avatar
Niels07
Copper Contributor
Jan 10, 2019

update cellnames in formula

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!

excel
Formulas and Functions

8 Replies

    • Ron Haggin's avatar
      Ron Haggin
      Copper Contributor
      May 15, 2019

      Detlef_Lewin 

       

      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. 

    • Niels07's avatar
      Niels07
      Copper Contributor
      Jan 10, 2019

      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.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jan 10, 2019

        You have to define names first (e.g. Name1 for D2, etc) and after that apply defined names to the formulas

Resources