View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default 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