Auto fill

D

dbasco

I already have an exsisting sequence in a worksheet. I now need to
expand the sequence. When I pull down on the fill handle the sequence
continues by 1's and not 10's as it should. Any suggestions.
 
G

Gord Dibben

Assuming you have

ABC10
ABC20
ABC30

Select at least two of the cells before dragging.


Gord Dibben MS Excel MVP
 
D

dbasco

Your example is the type of sequence that I have and I have done what
you suggested, but it still counts by ones's.
 
G

Gord Dibben

Try right-click and drag.

Release the button and select "Fill Series"

Does that work?


Gord
 
Top