Thread: Auto fill
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto fill

Try right-click and drag.

Release the button and select "Fill Series"

Does that work?


Gord

On 16 Jan 2007 14:17:32 -0800, wrote:

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

ABC10
ABC20
ABC30

Select at least two of the cells before dragging.


Gord Dibben MS Excel MVP

On 16 Jan 2007 13:30:43 -0800,
wrote:

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.