Tom’s Tutorials For Excel: Listing Column Letters Across and Down

Tom’s Tutorials For Excel: Listing Column Letters Across and Down

Here are formulas to display the column letter in any individual cell, or to list column letters horizontally across a row, or vertically down a column.

As shown in this first picture, you can display any cell’s column letter with the formula
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")

You can use that same formula, =SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1",""), and copy it across as such:

Here is the formula to list column letters vertically, as seen in the following picture:
=SUBSTITUTE(ADDRESS(1,ROW(),4),"1","")