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" wrote in message
...
| 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" wrote in message
...
| Can you set the default to Copy Cells rather than the Fill Series? And how
do
| you do that.... thank you in advance.

ToolsOptionsCalculation. Make sure you are on Automatic.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 14:05:02 -0800, "elfmajesty"
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" wrote in message
...
| Can you set the default to Copy Cells rather than the Fill Series? And how
do
| you do that.... thank you in advance.