if you drag the fill handle will it decrement the series

C

challa prabhu

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
 
J

JLatham

You can even get it to decrement when filling down a sheet. A couple of ways
to do that:
Easy way: put 10 in cell A1. choose the range of cells you wish to fill
with decreasing values, say A1 through A20. Choose Edit | Fill from the menu
bar and then choose [Series...] in the dialog that comes up, you'll see an
entry for "Step Value" enter -1 into that and click [OK]. A1 will have 10 in
it, the series will decrement to 0 at A11, and continue down to -9 at A20.

Alternately you can start your series as with
A1 holding 10
A2 holding 9
select both cells and grab the fill handle and head down the sheet.
 
Top