How to Autofill Letters A, B, C Sequentially in Excel
Question details
The user wants to generate an alphabetical sequence (A, B, C) using the fill handle instead of manually copying or typing letters.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Generating an automatic alphabetical list in a column or row for indexing, categorization, or formatting purposes.
- Observed behavior
- Excel's default fill handle copies the starting letter repeatedly instead of continuing the alphabetical sequence like it does for numbers or dates.
Ensure your starting cell contains only a single letter (uppercase or lowercase) without any trailing spaces. If you plan to use a custom list, decide beforehand whether you need uppercase, lowercase, or both.
Generate Letters Automatically Using Formulas
Use a dynamic formula to calculate the next letter based on the ASCII character code of the previous letter.
By combining the CHAR and CODE functions, Excel can mathematically determine the next letter in the alphabet. The CODE function gets the numeric ASCII value of your starting letter, adds 1 to it, and the CHAR function converts that new number back into text.
Type 'A' (or 'a' for lowercase) in your first cell, for example, cell A1.
In the immediate next cell (A2), type the formula: =CHAR(CODE(A1)+1).
Press Enter. The cell will now display the letter 'B'.
Click on cell A2, hover over the bottom-right corner until the cursor turns into a plus sign, and drag it down or across to auto-fill the subsequent letters.

Create a Custom List for Drag-and-Drop Autofill
Define an alphabetical custom list in Excel settings so the fill handle inherently recognizes letters just like days of the week.
Easily Autofill Letters and Data Sequences in WPS Spreadsheet
WPS Spreadsheet fully supports Excel's CHAR and CODE functions, as well as Custom Lists. It offers a lightweight, high-performance environment to manage all your data sequences effortlessly, helping you boost productivity without additional costs.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet workbook.
- 2. Enter your starting letter: Type the first letter of your sequence (e.g., 'A') in a blank cell.
- 3. Apply the sequence formula: In the next cell, input =CHAR(CODE(A1)+1) and press Enter.
- 4. Drag to autofill: Use the fill handle at the bottom right of the cell to drag the sequence down to generate B, C, D, and so on.

Frequently Asked Questions
Why does the formula stop working properly after the letter 'Z'?
The formula relies on the ASCII character set. The numerical code for 'Z' is 90, and the next code (91) represents the '[' symbol. To generate double letters like AA, AB after Z, you would need a more complex nested formula combining multiple IF and CHAR functions.
Can I use this formula for lowercase letters?
Yes. If you start with a lowercase 'a' in your reference cell, the CODE function will read its specific ASCII value (which is 97). Adding 1 will correctly produce the subsequent lowercase letters like 'b' (98) and 'c' (99).
Will the custom list method work on other computers?
No, custom lists are saved to the Excel application on your specific device. If you share the file with colleagues, the drag-to-fill feature for letters won't work for them unless they also add the custom list to their own Excel settings. In shared files, using the formula method is recommended.
Is there a built-in function to generate a full alphabet array instantly?
In newer versions of Excel, you can combine the SEQUENCE function with CHAR to spill the entire alphabet at once. For example, entering =CHAR(SEQUENCE(26,,65)) will automatically generate a column containing the letters A through Z.




