I don't think you can change that behavior. But you can rightclick on the
autofill button and drag. When you let go, you'll see a list of things you can
choose from.
Thanks, Dave! I realize that ... the problem is the default is set to fill
series and you have to go into the list every time you use copy cells which
is the setting used 95% of the time. I appreciate your response.