how to fill alphabets in a series like abcd insted of 1234

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

Guest

Please help in filling the data in a series as alphabets insted of numbers.

Thanks
Abhijit
 
If you only want to fill in a repeating series of the letters A through Z
Try this:

Enter A through Z in cells A1:A26
Select that range

Then...from the Excel main menu:
<tools><options><custom lists tab>
Click the [Import] button

That will add the list to the Custom Lists available

Now you can put any letter in a cell and drag the fill handle to extend the
list.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
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

Series fill only copying and fill series greyed out 1
fill series with alphabetic 3
Filling cells 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
auto fill series 2
sumproduct assistance pleas 9
How fill cells with alpha series? 3
How can I fill alphabetic series in excel 3

Back
Top