Get a list of Excel column headings

Get a list of Excel column headings

March 15, 2019

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

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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