No, it is not supposed to be that way by default. You need to create it once
as a custom list then add that lists and from then on it will be available


Here's a formula so you don't have to type in all values by hand

in an empty sheet put this in A1

=SUBSTITUTE(ADDRESS(1,ROW(),4),1,"")

copy down to A256


while still selected copy A1:A256 and paste special as values in place.
While still selected do toolsoptionscustom lists and then import the list


--
Regards,

Peo Sjoblom





"SAL" wrote in message
...
The idea was not to type all of the entries, which is what I'm trying not
to
do. The list will go from A to IV, like the column headings in Excel,
only
that I will be data filling them down (not across). Isn't this suppose to
be
a default in Excel.

I'm hoping it doesn't need to be typed manually.

Thanks,
SAL


"Pranav Vaidya" wrote:

Hi SAL,

To the best of my knowledge, this is governed by the custom list setting
of
Excel.
If you want to use this more often then, goto
Tools--Options--Custom Lists
here type A,B,C...Y,Z one below the other and add this list to the
existing
list of values.

Once this is done you can get the desired ouuput on dragging the
selection.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"SAL" wrote:

Hi Everyone,

In column A, Rows 1-3, I have entries A, B, and C. When I highlight
the
three rows and drag the data fill handle down, I get a repeat of A, B
and C
all the way down. I was thinking I would get D, E, F, etc. Am I doing
something wrong or is there a setting that needs to be changed
somewhere?

Thanks,
SAL