I have worksheets that have 60K rows and more. If I write a formula in the
top row is there an easy way to copy it down with out using page down. I
know that if there is already something in the column you can hit the end key
and the down arrow. I need something that would work to copy the formula
down in the empty column to the same number of rows of the other columns.
Hope this make sense.

Jordan,

Double click the fill handle (the black box at the bottom right of a
selected cell) and the formula will fill down as far as there are data in the
adjacent column.

Mike

"Jordan" wrote:

I have worksheets that have 60K rows and more. If I write a formula in the
top row is there an easy way to copy it down with out using page down. I
know that if there is already something in the column you can hit the end key
and the down arrow. I need something that would work to copy the formula
down in the empty column to the same number of rows of the other columns.
Hope this make sense.