Thread: How to keep a cell ref in formula unchanged when the ref cell move
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How to keep a cell ref in formula unchanged when the ref cell move
Instead of =C1, try:

=INDIRECT("C1")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Clifton Ford" wrote:

If a formula in one cell references, for example, cell C1, how can I keep the
formula refering to cell C1 when cell C1 moves to another cell by inserting
or dragging.
Reply With QuoteReply With Quote