Creating a Series of Letters in Excel

istock_baona_comp
istock_baona_comp
13

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.

Share this content

Replies

Please login or register to join the discussion.

avatar
By Data Entry Services
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
northandy
Jun 26th 2015 01:11

Thank you, Ramon! I appreciate your kind feedback.

Thanks (0)
avatar
By Juvelyn Reyes
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
David1207
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Super Supu
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
jk
Jun 26th 2015 01:11

Thanks for sharing your thoughts!

Thanks (0)
avatar
By chakravarthi
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

My pleasure! I appreciate the feedback!

Thanks (0)
avatar
By Razu Ahmed
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By Kunle Oyateru
Jun 26th 2015 01:12

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

Thanks (0)
avatar
Kunle Oyateru
Aug 19th 2015 22:20

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 (1)
avatar
brettmoan
Oct 4th 2016 14:40

Thanks very much. This is exactly what I was looking for!

Thanks (0)