Auto Fill Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
Thank you very much, that worked!

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