Forgive me if this has been posted already.
Example: I renamed cell A1 to Apple, A2 to Banana, A3 to Chair.
Down in cell a50 I was using simple formulas a1+a2*a3. then copying the formula into column b50, c50,... Now when I use the formula SUM(Apple+Banana*Chair) and try to copy it into cell b50, It doesnt change the formula to SUM(B1+B2*B3).
Is there an easy way I solve this issue?
Bookmarks