Copying Cells

[Vince]

I've downloaded the NCAA 2006 Mens basketball tracker. It only allows you to
track 5 peoples picks. I want to expand this to 20. Everything copies ok,
except the cell references. For the first game, it needs to reference cell
d8 on the first sheet, the second game is d12, etc. when i copy the
formulas, it automattically changes the d to an f. i need all of the
formulas on the columns i've added to remain the same as the five original.
I've tried paste special, but to no avail. I really don't want to change
over 100 cells, to run my tournament. Any help would be appreciated.

 

[Rich Mcc]

make the formula an absolute refrence,,

$d8

instead of d8

 

[Terry Bennett]

Use absolute references ...

So, to reference cell D8 and ensure that this does not alter, use =$D$8