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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a list in a column that just uses the alphabet....What
should I do?
 
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
 
It's probably better to create a list in alphabetical order with then
letters, then select it, then do tools>options>custom 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill series with alphabetic 3
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0
auto fill series 2
Clarified Post Convert Single Alpha to Side-by-Side (Not Cut n Pas 2
Alphabetize in multiple columns 2
How to sort entire spreadsheet by one column sort 5
Set chart series endpoint dynamically 0
Transpose, but how? 0

Back
Top