View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
George Gee George Gee is offline
external usenet poster
 
Posts: 109
Default How do I create a formula repeated on the adjacentt columns?

Select cell C3.
Move your curser to the fill handle (lower right of cell).
When the curser becomes a black cross, left-click and
drag down as far as you wish.


George Gee



"Excelless" wrote in message
...
I am trying to make the same operation for each column - the only
difference
is in the rows, e.g.
C3=A3*B*
C4=A4*B4, etc.

I don't want to have to re-enter a similar formula for each added row.

Thanks.