Autofill defaults
 

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".

Autofill defaults
 

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.

zoolady wrote:

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

Autofill defaults
 

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

"zoolady" wrote:

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".

Autofill defaults
 

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".

"Sean Timmons" wrote:

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

"zoolady" wrote:

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".

Autofill defaults
 

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

zoolady wrote:

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".

"Sean Timmons" wrote:


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

"zoolady" wrote:


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".