How to change columns from numbers to letters

[carolmarie]

Hi folks

I think this will be an easy one for you clever people. I have had this before and for the life of me cant work how to change the columns

I have a spreadsheet that has columns A,B,C, etc that are now appearing as 1,2,3 - I want them to be letters and cant work out how to change them back.

thanks in advance

 

[Weazel]

could be you have the R1C1 reference style option turned on...
depending on the version of excel you are using you can check under options and see if it is checked.

In excel 2010 its under options, formulas.

 

[VoG]

Look here Columns and rows are labeled numerically in Excel

 

[Peter_SSs]

Take a look here.