Auto Fill Problem

[Guest]

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,

 

[Peo Sjoblom]

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 edit>paste special and select
values
the do tools>options>custom 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

 

[Guest]

Thank you very much, that worked!

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