Change absolute cell reference in formula

  • Thread starter Thread starter Mark Christensen
  • Start date Start date
M

Mark Christensen

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
 
Find/replace

--
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
| 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
|
|
 
Excellent! I didn't realize you could use Replace with formulas. Exactly
what I was looking for! Thanks.
 
Back
Top