Data Fill

[Guest]

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

 

[Guest]

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,

 

[Guest]

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

 

[Guest]

I think it still needs to be typed manually, but only once.
Once entered, it can be used in any direction (down or across)

 

[Peo Sjoblom]

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