Dave

Either..........

1. Enter a100 in A1 and a99 in A2 then drag down or

2. Enter a100 in A1 and =A1-1 in A2 and drag down.

AFAIK you cannot change the ascending order of Autofill when only 1 cell has a
value.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 07:42:03 -0700, "Dave C."
wrote:

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.