Count down with auto fill?
 

Howcome I can't count down with autofill? If I put a number into cell A0 and
then make cell A1 = A0 - 1, when I auto fill it doesn't count down in - 1
decrements.

Count down with auto fill?
 

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

Count down with auto fill?
 

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

Count down with auto fill?
 

If you select A2 and get the black cross at the bottom right of cell A2
and drag it down the numbers should decrement.

What happens on you sheet. Do the values stay the same? If so is the
calculation mode set to manual (tools, options, calculation) if so make
it automatic?

If it is not that you need to tell us what is happening

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

Count down with auto fill?
 

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
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