With C1 highlighted, put your mouse pointer on the fill box (the small box
on the bottom right corner), and double click.

Neat, eh?

Regards,
Fred.

"Mark246" wrote in message
...
Excel 2007...

I put a formula in cell C1.
I want to copy it down to the end of the column, but the column has
140,00 records.
It takes Several minutes to scroll manually.
Is there a faster way to do it?

Thanks, in advance.

Mark246