G
Guest
Try Tools -> Options -> Custom Lists and import the list. You'll need to
type it out once and you should be set.
type it out once and you should be set.
B
Bernard Liengme
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
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
S
silas
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
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
R
RagDyer
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.
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.
S
silas
Barb and Bernard, thank you both very much for helping out an old man who
can't remember much of nothin' these days
silas
..
can't remember much of nothin' these days
silas
..