1. Home
  2. MS Office

How To Autofill Letters From A-Z In Excel

Microsoft Excel has a neat autofill feature that can complete a series like days of the week, months of the year, or numbers in a series e.g., odd or even numbers, etc. Unfortunately, this feature doesn’t cater to the letters of the alphabet. This means you cannot autofill letters from A-Z in Exce using this same feature. You can work around it by using a formula.

Autofill In Excel

If you’ve never heard of this feature, it works like this. If you’re trying to autofill the months in a year, you will type the first month i.e., January in one cell, then type February in the next cell. Select both and move the cursor to the bottom right corner of the second cell (the one with February in it). It should change to a plus sign. Click and drag it all the way down and it will fill in the rest of the months for you. This is also useful for filling formulas.

When you use this with letters of the alphabet though, it doesn’t work. To autofill letters from A-Z, you need to use a formula.

Autofill Letters From A-Z

In Excel, type the letter A in a cell. In the next cell, enter the following formula and replace the cell address with the cell address for the cell you’ve typed A in. The cell you enter the formula in will show you the letter B.

=CHAR(CODE(A1) + 1)

Next, click the bottom right of the cell you’ve pasted the formula in and the cursor will turn into a plus sign. Drag it down and the letters will autofill.

You can start at any letter. You don’t necessarily have to start with the letter A. Once you reach the end of the alphabet though, this formula will start filling it in with other characters like square brackets, underscore, backtick, and then the letters will start again in small case. It will not start filling in the letters like Excel does for the columns when it runs out of letters.

The formula makes use of the Char function which can fill in ASCII values. These values exist in a series which is what you can use to your advantage but it has its limitations. You can restart the series by typing A in the next cell once you reach Z. Unfortunately, if you try and use AA, AB, and AC, and try and create a series out of it like you can with odd or even numbers, Excel will not follow it.

Leave a comment