When I enter 1, 2, 3 in a1, a2 & a3, respectively, then select the cells and
drag down, the numerical sequence continues (4, 5, 6, etc). However, if I do
the same with a, b, c, dragging merely repeats the order (a, b, c, a, b, c)
rather than continuing the sequence (d, e, f, etc.). I know I've done this
before but I can't remember how.
Thanks,
silas
Barb Reinhardt - 08 Nov 2007 19:01 GMT
Try Tools -> Options -> Custom Lists and import the list. You'll need to
type it out once and you should be set.

Signature
HTH,
Barb Reinhardt
> When I enter 1, 2, 3 in a1, a2 & a3, respectively, then select the cells and
> drag down, the numerical sequence continues (4, 5, 6, etc). However, if I do
[quoted text clipped - 5 lines]
>
> silas
Bernard Liengme - 08 Nov 2007 19:05 GMT
Generally Excel can do an automatic range fill with numbers (1,2,3 or 15,
20, 25); with dates which are actually numbers anyway, with text having
numbers (q1, q2...), and with date thinks like days of the week and months.
To have a,b,c become the full alphabet you need to add a custom fill series.
You did not say what version you have but Help will tell you how.
best wishes

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> When I enter 1, 2, 3 in a1, a2 & a3, respectively, then select the cells
> and drag down, the numerical sequence continues (4, 5, 6, etc). However,
[quoted text clipped - 5 lines]
>
> silas
silas - 08 Nov 2007 20:34 GMT
Barb and Bernard, thank you both very much for helping out an old man who
can't remember much of nothin' these days ;)
silas
.
> Generally Excel can do an automatic range fill with numbers (1,2,3 or 15,
> 20, 25); with dates which are actually numbers anyway, with text having
[quoted text clipped - 13 lines]
>>
>> silas
RagDyer - 08 Nov 2007 20:19 GMT
If all you'll *ever* want is A to Z, then manually entering the alphabet
into the "Custom List" is the way to go.
However, if you might need lettering beyond Z, similar to the column headers
in XL (AA, AB, AC, ... BA, BB, BC, ... etc),
You can do something like this:
In A1, enter this formula:
=IF(ROW(A1)>26,CHAR(INT((ROW(A1)-1)/26)+64)&CHAR(MOD(ROW(A1)-1,26)+65),CHAR(ROW(A1)+64))
And copy down as needed.
Row 500 will get you to "SF".
NOW, while these rows are *still* selected,
Right click in the selection and choose "Copy".
Right click again and choose "PasteSpecial",
And click on "Values", then <OK>, then <Esc>.
What you've done here, is simply eliminated the formulas, and left the
actual text values behind.
You can now *automatically* copy them to the "Custom List".
NOW, while these rows are *still* selected,
From the Menu bar,
<Tools> <Options> <Custom Lists> tab,
You'll see your selected range already entered in the "Import List" box by
default.
Simply click on <Import>, then <OK>.
You can now auto fill alphabet combinations.
BTW, you'll find that even though you might have imported upper case letters
into the "Custom List" file,
XL will auto fill with whatever case you start your list with.

Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> When I enter 1, 2, 3 in a1, a2 & a3, respectively, then select the cells
> and drag down, the numerical sequence continues (4, 5, 6, etc). However,
[quoted text clipped - 5 lines]
>
> silas