Hello,

I have a column with a repeated formula working out something. The formula
accesses data in the same row in other columns - e.g this goes down one
column (this is from row 619):
=IF(D619<"",D619-SUM(G619:AB619)-$N$2,
IF(C619<"",E617+C619-SUM(G619:AB619), E617 - SUM(G619:AB619)))

When I cut and paste cells in the column referenced by the formula cell,
Excel changes the formula accordingly messing everything up.

In frustration I want to change all references to have '$' before them e.g.
$D$619 but to do this by hand would take many many hours due to the hundreds
of rows. Is there any easy way to do this or stop Excel changing my formulas
on a cut and paste? BTW. I can copy, paste and then delete to avoid the
problem but it is inconvenient so not my preference.

Thanks,
Ben