Creating a Series of Letters in Excel

istock_baona_comp.jpg

istock_baona_comp
istock_baona_comp
12

By its very nature as a spreadsheet, it's easy to create a series of numbers in Excel. For instance, you can enter the number 1 in cell A1, hold down the Ctrl key, and drag the fill handle in cell A1 down to create an instant series of numbers. For the uninitiated, the Fill Handle is the little black notch in the right-hand corner of the active worksheet cell. Regardless, most users don't realize that you can configure Excel to create a series of letters in a similar fashion.

First we need to create the list itself. If you like, you can type the letters A through Z down a column or across a row. But, there's an easier way:

1. In a blank worksheet, press F5 to display the Go To dialog box.

2. Enter A1:A26 in the Reference field, and then click OK.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

These are great Excel tips. These techniques are really useful to a lot of Excel users. Thanks for sharing.

Thanks (0)

Thank you, Ramon! I appreciate your kind feedback.

Thanks (0)

A very helpful article in using Excel. Those who work as data entry professionals are surely grateful. Thanks for posting.

Thanks (0)

Thank you for sharing your thoughts, Clarissa! I'm so glad that you found my article helpful.

Thanks (0)

Thank you so much, its very easy and intresting to do. :)

Thanks (0)

Thanks for sharing your thoughts!

Thanks (0)

Thank you for sharing.....its really helpfull

Thanks (0)

My pleasure! I appreciate the feedback!

Thanks (0)

This is very essential for me.... Thanks for sharing us.

Thanks (0)

You're welcome! I'm glad you found exactly what you needed.

Thanks (0)

Thank you. Would there be any way of extending the list to cover "AA, AB, AC, etc" after "Z"?

Thanks (0)

For two Letters try
=IF(ROUNDDOWN((ROW()-1)/26,0)>0,CHAR(ROUNDDOWN((ROW()-1)/26,0)+64),"") & CHAR(MOD((ROW()-1),26)+65)
Once you get to 3 letters I think It would be easier to do a VBA function using a loop.

Thanks (0)