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
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:
Leave a Reply