Copy and lengthy paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
DTTODGG said:
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.
Click to expand...

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
 
gls858 said:
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
Click to expand...

I knew, I knew it would be simple!
Thank-you, thank-you!
How much time I can now save!
 
DTTODGG said:
I knew, I knew it would be simple!
Thank-you, thank-you!
How much time I can now save!
Click to expand...

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
 
Back
Top