Generate a list of all column headings in an Excel worksheet

Generate a list of all column headings in an Excel worksheet

November 25, 2017

If you're parsing data and you're looking for a way to generate a list of the column headings in an Excel worksheet to use as cell references, use this formula originally posted here.  

 

=IF(COLUMN()>26,IF(RIGHT(CHAR(IF(MOD(COLUMN()-1,26)=0,1,MOD(COLUMN()-1,26))+64),1)="Y",CHAR(INT((COLUMN()-1)/26)+64) & "Z",CHAR(INT((COLUMN()-1)/26)+64) & CHAR(IF(MOD(COLUMN(),26)=0,1,MOD(COLUMN(),26))+64)),CHAR(COLUMN()+64))&ROW()

 

 

 

You can just enter the formula n cell A1 and drag it to the right with CTRL + R.  

 

 

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