if you drag the fill handle will it decrement the series

Have you tried it?


"ajbanana" wrote:

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 will it decrement the series

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.

"ajbanana" wrote:

if you drag the fill handle will it decrement the series