When you drag down using the *right* mouse button, a menu should pop up at
when you release it, with various options on.

--
Andy.


"Dave C." wrote in message
...
Thanks for the input Andy. I tried that and it did not seem to work. I
wonder if I need to close the active wb and then reopen it and try again.

"Andy B" wrote:

Hi
One way is to drag down with the right mouse button and then select
Series .
.. . and select -1 in the Step field.

--
Andy.


"Dave C." wrote in message
...
All,

I am seeking information on how to change the default auto fill order
from
ascending to descending when using alpha numeric entries.

To clarify, if you enter data into a cell and then click the lower
right
corner and drag to the next lower cell(s) the value increases. I would
like
it to decrease. How can I set that up.