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

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




wrote in message
...
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

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

" wrote:

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

Maybe =$G$6 will do.


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote:

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

On Nov 29, 11:25 am, Gord Dibben <gorddibbATshawDOTca wrote:
Maybe =$G$6 will do.

Gord Dibben MS Excel MVP



On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote:
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- Hide quoted text -

- Show quoted text -

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

Tom

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

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

On Nov 29, 11:25 am, Gord Dibben <gorddibbATshawDOTca wrote:
Maybe =$G$6 will do.

Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote:
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