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
Try and change some of the options.
