auto fill options

Can you set the default to Copy Cells rather than the Fill Series? And how do
you do that.... thank you in advance.

I don't think so but an easy next best solution is to hold Ctrl down as you
drag the fill handle.

--
Jim
"vic" <vic@discussions.microsoft.com> wrote in message
news:0B1F7FB9-E010-4F98-847C-B6FE25E4FC3B@microsoft.com...
| Can you set the default to Copy Cells rather than the Fill Series? And how
do
| you do that.... thank you in advance.

Funny enough - I'm trolling the board to see if I can switch my fill handle
to go BACK to doing a regular fill. Somehow, it is stuck on Copy Cells (have
no idea why) and I cannot autofill my formulas anymore by dragging the fill
handle! Any suggestions??

Thank you.


"Jim Rech" wrote:

> I don't think so but an easy next best solution is to hold Ctrl down as you
> drag the fill handle.
>
> --
> Jim
> "vic" <vic@discussions.microsoft.com> wrote in message
> news:0B1F7FB9-E010-4F98-847C-B6FE25E4FC3B@microsoft.com...
> | Can you set the default to Copy Cells rather than the Fill Series? And how
> do
> | you do that.... thank you in advance.
>
>
>

Tools>Options>Calculation. Make sure you are on Automatic.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 14:05:02 -0800, "elfmajesty"
<elfmajesty@discussions.microsoft.com> wrote:

>Funny enough - I'm trolling the board to see if I can switch my fill handle
>to go BACK to doing a regular fill. Somehow, it is stuck on Copy Cells (have
>no idea why) and I cannot autofill my formulas anymore by dragging the fill
>handle! Any suggestions??
>
>Thank you.
>
>
>"Jim Rech" wrote:
>
>> I don't think so but an easy next best solution is to hold Ctrl down as you
>> drag the fill handle.
>>
>> --
>> Jim
>> "vic" <vic@discussions.microsoft.com> wrote in message
>> news:0B1F7FB9-E010-4F98-847C-B6FE25E4FC3B@microsoft.com...
>> | Can you set the default to Copy Cells rather than the Fill Series? And how
>> do
>> | you do that.... thank you in advance.
>>
>>
>>