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,

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,

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,

Hello,

Thanks for the reply.... I'm able to see the fill handle I just cant
Double-Click the fill handle to copy the cells down instead I have to drag
them manually all the way down.

Thanks,

"Duke Carey" wrote:

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,

Double-clicking the fill handle works the same in Excel 2007 as before I
find.

This is what I did. New sheet. Entered "abc" in C1:C10. Entered 123 in
D1. Selected D1 and double-clicked the fill handle. 123 was copied done to
D10.

--
Jim
"Marilyn" wrote in message
...
| Hello,
|
| Thanks for the reply.... I'm able to see the fill handle I just cant
| Double-Click the fill handle to copy the cells down instead I have to drag
| them manually all the way down.
|
| Thanks,
|
| "Duke Carey" wrote:
|
| 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,
|