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.


Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com