Z zoolady Oct 23, 2009 #1 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".
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".
D Dave Peterson Oct 23, 2009 #2 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.
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.
S Sean Timmons Oct 23, 2009 #3 The default option is based on what Excel thinks you are attempting to do. The default will not alays be fill series...
The default option is based on what Excel thinks you are attempting to do. The default will not alays be fill series...
Z zoolady Oct 26, 2009 #4 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".
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".