If the formula column is adjacent to another column that extends down the 40000
rows just double-click on the fill handle of of the formula cell.

Alternative if not an adjacent column.................

Put your formula in say D1 then click on the namebox and type D1:D41000 and
<ENTER

Now hit CTRL + D to copy to that range.


Gord Dibben MS Excel MVP


On Thu, 19 Jan 2006 20:29:02 -0800, busman
wrote:

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.