Autofill defaults

[zoolady]

Is there a way to change the defaults on Autofill? I want my default on the
Autofill to be "copy cells" instead of "fill series".

 

[Dave Peterson]

You could rightclick and drag down.

You'll be asked what you want to use when you get to the bottom and let go of
the mouse button.

 

[Sean Timmons]

The default option is based on what Excel thinks you are attempting to do.
The default will not alays be fill series...

 

[zoolady]

Thanks, it's not the answer I was hoping to hear. You would think if I
always "copy" and don't use fill that Excel would learn that and would
default to "copy".

 

[Bob I]

If you don't see the "+" for Copy press CTRL button.