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. This feature excels with other functions, and while it doesn’t input letters automatically, we’ve discovered a solution to make it work for you. With the help of a simple formula, this article teaches you how to autofill letters in Excel, from A-Z.
Autofill Letters From A-Z
Once you know how to autofill A to Z in Excel, you’ll be doing it all the time. Yes, it’s that helpful. Here’s what the process looks like:
1. Type A in a cell.
2. Type =CHAR in the cell below it.
3. In the same cell, continue building the formula by referencing the A. For example, your formula might be =CHAR(A1) if it’s in cell A1.
4. Now type +1, and then close the formula with a final parenthesis so it resembles this: =CHAR(CODE(A1)+1).
5. Press Enter. The letter B should now be present.
6. Select the B and notice the small square at the bottom-right of the cell.
7. Click and hold the square and then drag it down the column. Let go after a few cells. You should see new letters!
Congratulations! You’ve learned how to add the alphabet in Excel without manually typing each letter.
Tips for Autofilling A to Z in Excel
You don’t necessarily have to start with the letter A; any letter works. 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.
More Pages Like This
If you liked this tutorial, you’ll enjoy similar Excel guides we’ve simplified for you:
- Learn how to insert a worksheet from another workbook to consolidate your work.
- If you work in new sheets often and you want consistent formatting across the board, it’s easy to do that in Excel.
- Excel has a lot of tools and menus, so we’ve got you covered if you need to strikethrough some text in Excel.
- This software is versatile. If you like lists (who doesn’t?), you’ll love to make check marks in Excel.
Why can’t Excel just do alphabetical fill itself, complete with AA, AB etc when required, instead of having to use hacks like this.
Put some data in the first few cells, then fill down, and Excel figure out the pattern.
It’s a pity AI is used to harvest our data instead of useful functions like this!
If you want to use two letter, you can expand on the one letter handle with the following that copies the first letter than calculate the next one.
=CHAR(CODE(LEFT(A1, 1)) & CHAR(CODE(RIGHT(A1, 1) + 1)
I think your formula might need a relative not an absolute reference — your suggestion got me started but the formula below worked better — I am a novice so I may be wrong — thank you
=char(code(R[-1]C)+1)
I do not know how to write this in A1 format
Brilliant ! Keep up the good work
To make the next consecutive alphabetical list of AA, AB, AC, etc., that imitates Excel columns, assume”A” is visible in cell A2. Restart by typing “AA” in the cell after “Z”. Then in the next cell insert the formula =CONCATENATE(($A$2),CHAR(CODE($A2)+1)). Draw the formula down to make a column or row of labels that mimic the Excel double-letter pattern through AZ. Restart again by typing BA, then write another similar formula that concatenates a static “B” cell ($), with the added A-Z characters. Do it again & again until ZZ if you wish. It isn’t wholly auto-fill, but it gets there.