Double click the Fill Handle of B1 when you have it selected.

http://www.ozgrid.com/Excel/excel-fill-handle.htm



--
Regards
Dave Hawley
www.ozgrid.com
"tran1728" wrote in message
...
Good morning, pls help me,

A B
9800 =A1*2
9800
9800
9800
9800

I want copy formula B1 and Paste B2 to ....., stop a t the last row of A.

Thanks