Question about Excel Re: Column headings

SubZeroX

Senior member
Oct 24, 2001
716
0
0
For some reason the column headings have become numbers and not letters so it's hard for me to make a formula. How can I change it back? This is annoying. I'm using Excel XP.
 

kranky

Elite Member
Oct 9, 1999
21,019
156
106
Go to Tools -> Options -> General tab and make sure "R1C1 reference style" is unchecked.
 

SubZeroX

Senior member
Oct 24, 2001
716
0
0
Thank you Kranky!!!

I've had to live with this nightmare for a long time and finally it's fixed!