How to keep a cell ref in formula unchanged when the ref cell move

C

Clifton Ford

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

Ron Coderre

Instead of =C1, try:

=INDIRECT("C1")

Does that help?

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

XL2002, WinXP-Pro
 
Top