| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to set Clipboard defaults | Excel Discussion (Misc queries) | |||
| Set Defaults | Charts and Charting in Excel | |||
| Changing defaults | Excel Discussion (Misc queries) | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Changing Defaults in VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
