With 100 in A1

In A2 enter = A1-1

In namebox type A2:A100 and hit ENTER

Now hit CTRL + D


Gord Dibben MS Excel MVP

On Mon, 21 Aug 2006 06:53:02 -0700, Chris <Chris@discussions.microsoft.com>
wrote:

>If i type in a cell A2 "= A1 - 1", and auto fill, excel doesn't count down.
>
>
>
>"Dav" wrote:
>
>>
>> Excel will autofill as you suggest either by putting a value in the
>> first cell then putting that cell -1 in the cell below and dragging
>> down. Or by putting a value in a cell, one lower in the cell below and
>> selcting both and dragging down.
>>
>> However what is cell A0, a spreadsheet starts at cell A1,
>>
>> Regards
>>
>> Dav
>>
>>
>> --
>> Dav
>> ------------------------------------------------------------------------
>> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
>> View this thread: http://www.excelforum.com/showthread...hreadid=573746
>>
>>