calculating cells without draging selection

[tinmanjo]

Hi,

 

I have want to create 2 columns of data which extend over thousands of cells, to simplify say i want to create a formula which is:-

 

Cell A1A =1

Cell B1A=A1A+1

 

 

how do i replicate this formula down to thousands of cells without having to drag the selection box down forever.

 

Is there a way to specify a reference grid to copy formulas to i.e: A1A:A16000

[sted]

i think if you fill in the first 2 rows or so correctly the copy them select row 3 then scroll to row 9999 and shift click then paste that should work

[srochford]

Fill in the first couple of cells

Press F5 (Goto) and enter the ref for the final cell

Press Shift END and you will highlight from where you are up to the bottom cell which contains data. You can then just use Fill Down to fill the range.

If you're filling to the right from where you are then basically the same - press F5, goto the last cell and press Shift END

[tinmanjo]

Fill in the first couple of cells

Press F5 (Goto) and enter the ref for the final cell

Press Shift END and you will highlight from where you are up to the bottom cell which contains data. You can then just use Fill Down to fill the range.

If you're filling to the right from where you are then basically the same - press F5, goto the last cell and press Shift END

 

Cheers for that, it worked, saves a heck of a lot of scrolling, this student had like 15000 rows to fill.

 

 

Thanks.