View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clifton Ford
 
Posts: n/a
Default How to keep a cell ref in formula unchanged when the ref cell move

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.