How can I autofill alphabetical characters from AAA to ZZZ in excel?

So if I type in the following data:

I want to be able to drag the handle in the bottom right to expand the list all the way to ZZZ if necessary. By default, excel just repeats the sequence I typed.

3 Answers

Change your data to rows instead of columns, there are not enough columns to get to ZZZ.

=CHAR(INT((ROW(1:1)-1)/26^2)+65)&CHAR(MOD(INT((ROW(1:1)-1)/26),26)+65)&CHAR(MOD((ROW(1:1)-1),26)+65)

Assuming you have Excel 2007 or later, start in column A with the formula:

=MID(ADDRESS(1,702+COLUMN()),2,3)

This just takes advantage of the fact that column 703 is AAA. If you start in a different column, adjust the value of 702 as needed.

In A1 write AAA In B1 write the following:
=SUBSTITUTE(SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT(A1&"1"))+1),"$",""),"1","")
and drag it in the same row to C1, D1 till you have the result you need
The formula

• read the cell before it (left column same row) with indirect
• Add 1 to the column
• Substitute $ with ""
• Substitute 1 with ""

Address Function return =Address(1,1) -->$A$1

From SUPERUSER QUESTION 867965 answered by SeanC