If I understand correctly, you want to set the cells as absolute
references.

In the formula, click the cell reference and then hit F4.

If you had A1, it'll become $A$1. This means this particular cell will
always be used, wherever you copy the formula. If you hit F4 again,
you'll get A$1, which means the row will always be 1, but the column
can change. Hit it one more time you'll get $A4, which means that
column A will always be referenced, but you can drag the rows. Hit F4
one more time, and you be back to your relative reference of A1.

Hope that helps,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=553287