You got the double-click of the fill handle to work but they say you
have to drag the border of the cell C1 and then the sentence is unfinished.
Dragging borders is something else again and I don't really see how it
applies in your question as it would cause a rearrangement (or a replacement)
of cells or column, rows..

Both fill handle and dragging borders are described in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ralngm" wrote in message ...
it really works..thanks again..but finally have to drag the border of the
cell in C1 in order to get..

"Pete_UK" wrote:

Assuming your data starts in A1, then in C1 enter this formula:

=A1*B1

Select C1 again and double-click the fill handle - this is the small
black square at the bottom right corner of the cursor, and
double-clicking it will cause the formula to be replicated down column
C for as many data items as you have in column B.

Hope this helps.

Pete