Forum Discussion
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 ...
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.
You have to define names first (e.g. Name1 for D2, etc) and after that apply defined names to the formulas