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.

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.

Yes, thanks much

"Ron Coderre" wrote:

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