How do I change column labels from numbers to letters?
 

I'm using Office 2003. Excel column labels used to be letters A-B-C etc, but
somehow got changed so both rows & columns have number labels. I would like
to go back to letters for column names, but haven't been able to find out how
to make the switch.

How do I change column labels from numbers to letters?
 

Gregg, tools, options, general, uncheck R1C1 reference style
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Gregg Hillyer" <Gregg wrote in message
...
I'm using Office 2003. Excel column labels used to be letters A-B-C etc,
but
somehow got changed so both rows & columns have number labels. I would
like
to go back to letters for column names, but haven't been able to find out
how
to make the switch.

How do I change column labels from numbers to letters?
 

Hi Gregg,

Tools Options General R1C1 reference style uncheck OK

HTH
Regards,
Howard

"Gregg Hillyer" <Gregg wrote in message
...
I'm using Office 2003. Excel column labels used to be letters A-B-C etc,
but
somehow got changed so both rows & columns have number labels. I would
like
to go back to letters for column names, but haven't been able to find out
how
to make the switch.