Generate a list of all column headings in an Excel worksheet
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()
![](https://static.wixstatic.com/media/af7fa4_a51e1567258f427089d1e999ee77ad2d~mv2.png/v1/fill/w_49,h_19,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/af7fa4_a51e1567258f427089d1e999ee77ad2d~mv2.png)
You can just enter the formula n cell A1 and drag it to the right with CTRL + R.