How to copy an unreferenced cell and keep the formula

[tomfabtastic]

Hi,

I have a formula in a cell, say, =G6. How can I copy this formula to
another cell. At present, when I copy the formula changes because it
is not referenced. When I copy, paste special with formulas the
formula still moves. Anyone have a solution without cutting and
pasting or referencing the cell ?

Thanks,
Tom

 

[Conan Kelly]

tomfabtastic,

in the formula "=G6", "G6" is the reference to another cell........a
"Relative" reference to another cell.

In order to adjust this formula so it will not change when you copy it to a
new cell, you need to make it "Absolute". Just use dollar signs to do that:

Chage:

=G6

to:

=$G$6

A reference can be completely relative:
G6

Completely absolute:
$G$6

or a mix of both absolute and relative:
G$6 (column will change when copying, but row won't)
$G6 (row will change, but column won't)

HTH,

Conan

 

[Lois]

Hi Tom, try adding the ' $' sign at the beginning of G, such as =$G9.

 

[Gord Dibben]

Maybe =$G$6 will do.


Gord Dibben MS Excel MVP

 

[tomfabtastic]

Maybe =$G$6 will do.

Gord Dibben MS Excel MVP







- Show quoted text -

Thanks for the suggestions. But is there an alternative to using the $-
signs and making the cell refence absolute ?

Tom

 

[David Biddulph]

You could use Insert/ Name/ Define to define a name for your G6 cell, and
then use that name in your formula.