Data Fill
 

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

Data Fill
 

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

Data Fill
 

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

Data Fill
 

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

Data Fill
 

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