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

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

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

I think it still needs to be typed manually, but only once.
Once entered, it can be used in any direction (down or across)
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"SAL" wrote:

> 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

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 tools>options>custom lists and then import the list


--
Regards,

Peo Sjoblom





"SAL" <(E-Mail Removed)> wrote in message
news:919BE7E9-D326-4F10-B5D0-(E-Mail Removed)...
> 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