View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default Copy and lengthy paste

DTTODGG wrote:
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