Hi!

Try this:

Assume you have a formula in A1 and want to copy it down to A40000.

Make sure your formula is using the correct reference style (relative,
absolute, mixed)

Select cell A1
Goto EditCopy
Hit function key F5
Enter A2:A40000
Click OK
With that range now selected....
Goto EditPaste

Note: The formulas still have to calculate. This just saves the trouble of
dragging for such a large range.

Biff

"busman" wrote in message
...
Is there any other way to copy a formula in a large column of data (40000
rows) other than dragging the formula down. This can take up to five
minutes
to drag down this many rows. I've been searching for a way by have had no
luck.