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

[Nick Hodge]

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

(e-mail address removed)
www.nickhodge.co.uk

 

[Gord Dibben]

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