software

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(quot;C1quot;)

Does that help?

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

XL2002, WinXP-Proquot;Clifton Fordquot; wrote:

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

Yes, thanks much

quot;Ron Coderrequot; wrote:

gt; Instead of =C1, try:
gt;
gt; =INDIRECT(quot;C1quot;)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Clifton Fordquot; wrote:
gt;
gt; gt; If a formula in one cell references, for example, cell C1, how can I keep the
gt; gt; formula refering to cell C1 when cell C1 moves to another cell by inserting
gt; gt; or dragging.