change excel auto column headers from numeric to alpha

[MarcieinHawaii]

Across the top of the Excel spreadsheet there are usually letters, ie., A,B,C
to head the columns. My Excel has numbers and I want to change them to the
usual letters. How do I do this?

 

[Dave Peterson]

Tools|options|General tab|Uncheck R1C1 Reference style

 

[L. Howard Kittle]

Tools > Options > General > R1C1 > Uncheck

HTH
Regards,
Howard