Get a list of Excel column headings
Excel column headings run from A to Z, and then begin to repeat the alphabet using A, then B, and so on as a prefix. It may be helpful to quickly get a list of the column headings for the purposes of referencing cells on a worksheet. Enter this formula:
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)
. . .in any cell and pull it down using ALT + D. It will correctly generate the column headings up to ZZ.


Thanks to Mike Rickson for posting this formula here.