Copy and lengthy paste

[DTTODGG]

This must be a simple key stroke.

I work out a formula in H2 cell - it works! So I want to copy that to the
rest of that column. It's a long column, I don't even know how long unless I
do an "END".

Is there some key stroke that after you "copy" the first cell, you can
"paste" to the rest of the column? Not forever, just to the end of the column
of data?

Thanks.

 

[gls858]

This must be a simple key stroke.

I work out a formula in H2 cell - it works! So I want to copy that to the
rest of that column. It's a long column, I don't even know how long unless I
do an "END".

Is there some key stroke that after you "copy" the first cell, you can
"paste" to the rest of the column? Not forever, just to the end of the column
of data?

Thanks.

Highlight the cell with your formula. Double click the little black square
in the lower right hand corner. This will copy the formula down the entire
column.

gls858

 

[DTTODGG]

Highlight the cell with your formula. Double click the little black square
in the lower right hand corner. This will copy the formula down the entire
column.

gls858

I knew, I knew it would be simple!
Thank-you, thank-you!
How much time I can now save!

 

[gls858]

I knew, I knew it would be simple!
Thank-you, thank-you!
How much time I can now save!

Glad to help. I use it all the time.
I gleaned that one from this group. I would give credit where
it's due but I can't remember who posted it. I'm sure it was
one of the "regulars".

gls858