Step value

[geza]

Hi everyone,

I noticed that many time the drag/double click option to increase the value
in the adjacent cell by value step = 1 (or 10, etc), doesn’t work (I don't
know why). In that case, I have to do it from the ‘Edit/Fill/Series.’ How
could I activate/deactivate the automatic function.

Thanks, Geza

 

[David Billigmeier]

You just have to give Excel a pattern to recognize. For example, put 1 in A1
and 2 in A2, then select both A1 and A2 and drag down, it will recognize that.

 

[geza]

thank you

You just have to give Excel a pattern to recognize. For example, put 1 in A1
and 2 in A2, then select both A1 and A2 and drag down, it will recognize that.