There is a setting in all version that has this functionality that turns it
on/off
in earlier versions it is under toolsoptionsedit and allow cell drag and
drop

in 2007 it is the office buttonexcel optionsadvanced and enable fill
handle and cell drag and drop

--


Regards,


Peo Sjoblom

"Marilyn" wrote in message
...
Hello,

I use to be able to copy a formula down to the remaining rows by double
clicking the fill handle but I can't seem to do that now. I have to drag
it
all the way down.

Is there a setting in Excel 2007 that turns this off?

Thanks,