Auto Fill Problem
 

I am trying to use the Auto Fill feature, selecting a range of values and
dragging the + to fill in the range.

My problem is that when I select A, B, C, D, and drag the box down, instead
of getting A, B, C, D, E, F, G, H, etc., I get A, B, C, D, A, B, C, D, A, B,
C, D,

How do I get it to continue the series, rather than duplication the above?

The cells are formatted "general". (Windows XP SP2, Excel 2003)

Thank you,

Auto Fill Problem
 

You need to create a custom list first
put the alphabet in let's say A1:A26 by typing them manually or by putting
this in A1
and copy down

=CHAR(ROW(65:65))


then select A1:A26, copy the values and do editpaste special and select
values
the do toolsoptionscustom lists, click import and add. From now on you
will get what you
expected. Of course you could always use the formula solution as well


--


Regards,


Peo Sjoblom


"John Gregory" wrote in message
...
I am trying to use the Auto Fill feature, selecting a range of values and
dragging the + to fill in the range.

My problem is that when I select A, B, C, D, and drag the box down,
instead
of getting A, B, C, D, E, F, G, H, etc., I get A, B, C, D, A, B, C, D, A,
B,
C, D,

How do I get it to continue the series, rather than duplication the above?

The cells are formatted "general". (Windows XP SP2, Excel 2003)

Thank you,

Auto Fill Problem
 

Thank you very much, that worked!

I would have expected that an alphabetical list would have been included as
a standard item.

"Peo Sjoblom" wrote:

You need to create a custom list first
put the alphabet in let's say A1:A26 by typing them manually or by putting
this in A1
and copy down

=CHAR(ROW(65:65))


then select A1:A26, copy the values and do editpaste special and select
values
the do toolsoptionscustom lists, click import and add. From now on you
will get what you
expected. Of course you could always use the formula solution as well


--


Regards,


Peo Sjoblom


"John Gregory" wrote in message
...
I am trying to use the Auto Fill feature, selecting a range of values and
dragging the + to fill in the range.

My problem is that when I select A, B, C, D, and drag the box down,
instead
of getting A, B, C, D, E, F, G, H, etc., I get A, B, C, D, A, B, C, D, A,
B,
C, D,

How do I get it to continue the series, rather than duplication the above?

The cells are formatted "general". (Windows XP SP2, Excel 2003)

Thank you,