How do I drag a,b,c,d down a column into a series?
 

I want to create a list in a column that just uses the alphabet....What
should I do?

How do I drag a,b,c,d down a column into a series?
 

Hi,

You can use this for lower case letters:

=CHAR(96+ROW(A1))
copy down

if you want upper case letters then use 64 instead of 96

HTH
Jean-Guy

"BethfromNJ" wrote:

I want to create a list in a column that just uses the alphabet....What
should I do?

How do I drag a,b,c,d down a column into a series?
 

It's probably better to create a list in alphabetical order with then
letters, then select it, then do toolsoptionscustom lists and import and
add it. After that you only have to type in a or A and copy it down and it
will return a list


--


Regards,


Peo Sjoblom


"BethfromNJ" wrote in message
...
I want to create a list in a column that just uses the alphabet....What
should I do?