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

Either drag the cell with the formula down as much as required
(drag by the black cross on the bottom right corner)
Or just copy and paste the cell
If you have b1=a1/5 for example
as you copy b1 to b2,b3,b4 the formula will change to a2/5 etc etc

Steve


On Tue, 05 Sep 2006 09:33:01 +0100, Joyce
wrote:

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

Hi Joyce

If you mean you enter in C1
=A1+B1
Just copy that down column C for 1000 rows and the references will
change automatically to A2+B2, A3+B3 etc,

To copy down, hover your cursor over the bottom right corner of cell C1,
until it changes to a small black cross.
Double click and it will fill down the column provided there is data in
column B.
Otherwise, hold the left button down on the cross, and drag down as far
as required.

--
Regards

Roger Govier


"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

Hi Joyce,
see Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

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

Cheers Steve! That's so easy, I'd been trying to click and paste and jsut
wasn't working for me, obviously. Thanks!

"SteveW" wrote:

Either drag the cell with the formula down as much as required
(drag by the black cross on the bottom right corner)
Or just copy and paste the cell
If you have b1=a1/5 for example
as you copy b1 to b2,b3,b4 the formula will change to a2/5 etc etc

Steve


On Tue, 05 Sep 2006 09:33:01 +0100, Joyce
wrote:

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

Check Rogers' answer about the double click,
can save a lot of time


Steve

On Tue, 05 Sep 2006 09:58:02 +0100, Joyce
wrote:

Cheers Steve! That's so easy, I'd been trying to click and paste and jsut
wasn't working for me, obviously. Thanks!

"SteveW" wrote:

Either drag the cell with the formula down as much as required
(drag by the black cross on the bottom right corner)
Or just copy and paste the cell
If you have b1=a1/5 for example
as you copy b1 to b2,b3,b4 the formula will change to a2/5 etc etc

Steve


On Tue, 05 Sep 2006 09:33:01 +0100, Joyce
wrote:

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