Change absolute cell reference in formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Christensen - 12 Sep 2007 21:09 GMT

I've got a bunch of cells set up to be the sum of 2 specific cells. The
formula I'm using is ($G$216+$G$3617) for example. I now need to duplicate
this in column I so my new formula should be ($I$216+$I$3617) but when I cut
and paste from G to I, the formula is still referencing G, which is to be
expected. Is there a quick way to update the formulas so they reference I
instead? Thanks.

Mark

Reply to this Message

Jim Rech - 12 Sep 2007 21:14 GMT

Find/replace

Signature

Jim

| I've got a bunch of cells set up to be the sum of 2 specific cells. The
| formula I'm using is ($G$216+$G$3617) for example. I now need to duplicate
[quoted text clipped - 4 lines]
|
| Mark

Reply to this Message

Mark Christensen - 12 Sep 2007 21:20 GMT

Excellent! I didn't realize you could use Replace with formulas. Exactly
what I was looking for! Thanks.

> Find/replace
>
[quoted text clipped - 10 lines]
> |
> | Mark

Reply to this Message

Bernard Liengme - 12 Sep 2007 21:15 GMT

Use =G$216+G$3617
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> I've got a bunch of cells set up to be the sum of 2 specific cells. The
> formula I'm using is ($G$216+$G$3617) for example. I now need to duplicate
[quoted text clipped - 4 lines]
>
> Mark

Reply to this Message