How to Autofill Alpha Characters in Excel?

Alpha characters include alphabets from "a" to "z" in both small and capital styles. When we try to enter alphabets in Excel, we need to enter each and every letter in the column because we cannot use the autofill handle to do it. When we enter numbers, we can directly fill them using the autofill handle. If we make some changes to the Excel sheet, we can autofill alphanumeric characters in the sheet by using the autofill handle. This tutorial will help you understand how you can autofill alphanumeric characters in Excel.

Autofill Alpha Characters in Excel

Here we will use some advanced Excel options to complete the task. Let us see an uncomplicated process to understand how we can autofill alphanumeric characters in Excel using the autofill handle.

Step 1

Let us consider a new Excel sheet and enter all twenty-six letters manually in the sheet, then click on the options as shown in the below image.

Step 2

Then, as shown in the image below, click "Advanced" and then "Edit custom list" in the pop-up menu. 

Step 3

In the pop-up window, click on "New List," select the range where the characters are present, and click on "Import," as shown in the below image. Then click OK, and then click OK again to return to the Excel sheet.

Step 4

Next time we try to auto-fill with alpha characters, we can do that using the auto-fill handle.

Autofill Alpha Characters Using Formula

Here we will first use the CHAR formula to print A, then use the autofill handle to complete the task. Let us see an uncomplicated process to autofill alphanumeric characters using a formula.

Step 1

To get the first letter, click on an empty cell, enter the formula =CHAR(ROW(A65)) in the formula box, and press enter. 

Step 2

Now we can drag the auto-fill handle to fill the alphanumeric characters automatically, as shown in the below image.

Conclusion

In this tutorial, we used a simple example to demonstrate how we can autofill alphanumeric characters in Excel.