D-click only works if you have data in an adjacent column that runs down to
C14000.

I would just enter the formula in C1 then in the namebox type C1:C14000 and
ENTER.

Then CTRL + D to fill down to C14000.


Gord Dibben MS Excel MVP

On Mon, 25 Feb 2008 13:33:43 -0600, "Fred Smith" wrote:

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