Use absolute reference... =$A$1+$B$1

There are varations to hold the row absolute, or the column.

Do a formula and click on A1 then use F4 to toggle through the options of
absolute reference.

HTH
Regards,
Howard

"analyst storm" <analyst wrote in message
...
I want to fill a column of cells with the same fomula in each cell but when
a
drag the cells the formula keeps changing by adding 1 to each cell
reference.
I want the same formula in each cell over namy rolls in a column.