column heading

[Jackie]

Dear Gurus:


In each excel speadsheet, usually the column headings are
letters such as A, B,C, etc. however, sometimes, it will
become numbers such as 1,2,3..., just like the row
headings. What should I do to change the column headings
back to letters?

Thanks,

Jackie

 

[Paul]

Dear Gurus:

In each excel speadsheet, usually the column headings are
letters such as A, B,C, etc. however, sometimes, it will
become numbers such as 1,2,3..., just like the row
headings. What should I do to change the column headings
back to letters?

Thanks,

Jackie

Tools > Options > General tab
Uncheck "R1C1 reference style".

 

[Jackie]

No need to reply this. I found the same question and
answer in the group. Sorry I don't find it before I send
the message.

Thanks anyway,

Jackie

 

[John Wilson]

Jackie,

Tools/Options/General
Uncheck the R1C1 Reference Style

John