View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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,