Click on the Office button in the top left, choose Excel options from the
bottom of the dialog, then Advanced, and check Enable Fill Handle

"Marilyn" wrote:

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,