$ signs are your friends

$F$2 is absolute column and row.

$F2 is absolute column and relative row.

F$2 is absolute row and relative column.

Anything preceded by a $ sign will not change when dragged down or across.

See more on this in Help.


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 15:39:01 -0800, jchandler0614
wrote:

Can someone please let me know if there is a way to copy cell contents with
the cell drag and drop option without it increasing the value, but copy what
was in the contents i.e. "F2" in fields A1 through A12. and not F2 in field
A1 F3 in filed A2.

PLease hlep.