if you drag the fill handle will it decrement the series
 

if you drag the fill handle it will decrement the series

if you drag the fill handle will it decrement the series
 

On Wed, 31 Jan 2007 01:38:00 -0000, ajbanana
wrote:

if you drag the fill handle it will decrement the series

if you drag upwards

--
Steve (3)

if you drag the fill handle will it decrement the series
 

Ajbanana,

I think you're asking if there's a way to get it to decrement. If you put
in the first two numbers in the first two cells, select them, then drag the
fill handle, it will continue the series. If your first two numbers are
decrementing, it will continue.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"ajbanana" wrote in message
...
if you drag the fill handle it will decrement the series

if you drag the fill handle will it decrement the series
 

Yes.
if you select the cell value say 10, and press control and move the fill
handle up the cells, the value gets decremented - 9, 8, 7, 6, 5 and so on. If
you select the cell value say 10, and press control and move the fill handle
down the cells values gets incremented- 11, 12. 13, 14 and so on.

Note: If you you decrement beyond the base value - in this case assuming it
is 10 -Excel will display negative value.

Challa Prabhu


"ajbanana" wrote:

if you drag the fill handle it will decrement the series