Select the cell that contains the formula that you wish to copy
Point your cursor at the small black square at the lower right of the cell,
and drag it down the column as far as you require.
Excel will change the cell references automatically.

Hope this helps.

George Gee

"Joyce" wrote in message
...
I want to use the same formula a load of times in one column, the only
thing
differing being the cell number it's working on.
Kinda like adding up 2 cells on the left, and putting it in a new cell on
the right, and doing that 100 times