You can't.

Excel will always want to help.

Next best thing is to right-click and drag then release and "Copy Cells"


Gord Dibben MS Excel MVP

On Thu, 8 May 2008 09:50:01 -0700, Mark wrote:

I want to set the deaul for the fill handle to copy cells only.