Inserting formula for every cell in column

[bsb2013]

Lets say I want to make A1=B1+C1, A2=B2+C2 etc. and I want to apply this to every cell in column A. Is there a way to do this? or if I have to only do a finite number of cells, is there another method besides dragging the function? I'm working with about 25000 rows.

 

[MrKowz]

Try double-clicking that little black box that you normally "drag". That will copy the formula down to where Excel finds the first empty cell in column B.

 

[kidwispa]

Lets say I want to make A1=B1+C1, A2=B2+C2 etc. and I want to apply this to every cell in column A. Is there a way to do this? or if I have to only do a finite number of cells, is there another method besides dragging the function? I'm working with about 25000 rows.

If you move your mouse to the bottom right hand corner of cell A1 (so it shows a black cross) and double click, it will populate the formula down to your last row of data...

 

[bsb2013]

This seems to take me down to the last filled row of A, but I want to fill at least 2500 empty cells of A. Interesting excel feature though

 

[bsb2013]

nvm. It is working now. Thanks for the help