top of page

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.

bottom of page