| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Is there a way to count cells in a range based on fill color? | Excel Worksheet Functions | |||
| Auto fill option box disappeared | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Hybrid Mode
