Get a list of Excel column headings
- Sean O'Shea
- Mar 15, 2019
- 1 min read
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.