Thread: Rename name so formulas show name change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.newusers
John John is offline
external usenet poster
  
Posts: 3
Default Rename name so formulas show name change
Excel 2003

Cell A1 is named MyCell.
Cell A2 has formula "=MyCell".

I rename cell A1 in the toolbar to NewCell.
Cell A2 still has the formula "=MyCell".

How do I rename cell A1 to NewCell and have
it automatically change cell A2 to the formula "=NewCell"?

Thank you for your help.


Reply With QuoteReply With Quote