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 ...
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.