Column designations (A, B, C,..) are now numbers-how do I change
 

For my column headings that are normally A, B, C, etc. somehow they have
changed to 1, 2, 3, etc. They are now the same as my row designations.
How do I change them back?
Thanks

Column designations (A, B, C,..) are now numbers-how do I change
 

In the tools menu, select Options. In the Options dialogue box, click on
the General tab at the top. Uncheck the box next to R1C1 reference
style.

Click okay, and you should be good to go.


--
schall
------------------------------------------------------------------------
schall's Profile: http://www.excelforum.com/member.php...o&userid=30913
View this thread: http://www.excelforum.com/showthread...hreadid=505890

Column designations (A, B, C,..) are now numbers-how do I change
 

Tools Options General and clear the R1C1 checkbox
--
Gary''s Student


"LM" wrote:

For my column headings that are normally A, B, C, etc. somehow they have
changed to 1, 2, 3, etc. They are now the same as my row designations.
How do I change them back?
Thanks

Column designations (A, B, C,..) are now numbers-how do I change
 

Tools options general R1C1 uncheck

HTH
Regards,
Howard

"LM" wrote in message
...
For my column headings that are normally A, B, C, etc. somehow they have
changed to 1, 2, 3, etc. They are now the same as my row designations.
How do I change them back?
Thanks