How do I keep the exact existing formula when drag copying?
 

How do I keep the exact existing formula when drag copying?
 

I suspect you are looking for an absolute reference, try looking it up in
help for an explanation.

Basically

=Sum($A$1:$A$12)

will always refer to that range, wherever you drag/copy it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Excelchallenged" wrote in
message ...

How do I keep the exact existing formula when drag copying?
 

Make the references Absolute.

=$A$1 is absolute column and row

$A1 is absolute column and relative row.

A1 is relative row and column

A$1 is relative row and absolute column.

See help on relative and absolute cell references for more on this.


Gord Dibben MS Excel MVP


On Thu, 19 Oct 2006 13:43:02 -0700, Excelchallenged
wrote: