Change absolute cell reference in formula

's Computer Specifications

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

's Computer Specifications

Find/replace

--
Jim
"Mark Christensen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| 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
|
|

's Computer Specifications

Use =G$216+G$3617
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mark Christensen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

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

"Jim Rech" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Find/replace
>
> --
> Jim
> "Mark Christensen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | 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
> |
> |
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shortcut to change change cell reference to Absolute reference?	=?Utf-8?B?cmljaGs=?=	Microsoft Excel Worksheet Functions	12	5th Dec 2009 12:24 AM
Re: Change linked cell reference to absolute	AussieBec	Microsoft Excel Programming	3	5th Aug 2009 01:06 AM
Change a cell reference from relative to absolute	Fred Holmes	Microsoft Excel Misc	2	4th Jun 2009 02:03 AM
Right click on cell to set formula reference as absolute	=?Utf-8?B?TmVpbA==?=	Microsoft Excel Misc	1	14th Mar 2006 07:02 PM
How do I change a cell from absolute reference to relative referen	=?Utf-8?B?c2ltb25zZXo=?=	Microsoft Excel Misc	1	17th May 2005 08:39 PM