Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gregg Hillyer
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle
 
Posts: n/a
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulas to numbers Steve New Users to Excel 2 September 16th 05 12:07 AM
Macro to change Chart Range when inserting a column Mark Charts and Charting in Excel 1 September 13th 05 01:12 PM
why have column letters changed to numbers in excel JCereda Excel Discussion (Misc queries) 1 May 5th 05 12:36 PM
row numbers & column letters ALOlson21 Excel Discussion (Misc queries) 3 December 10th 04 05:45 PM
How do I change column labels from numbers to letters in Excel? AllisonCincy Excel Discussion (Misc queries) 2 December 9th 04 12:55 AM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"