numerical columns
When I open Excel, my column labels are numerical instead of alphabetical and
I can't figure out how to change them back. Every work sheet that I open is the same. I am using Office 2003. |
numerical columns
ToolsOptionsGeneral tab, uncheck R1C1 reference style
-- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
numerical columns
Click on Tools | Options | General tab, then uncheck R1C1 Reference
style. Hope this helps. Pete On Sep 23, 3:57*pm, Billie wrote: When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. *Every work sheet that I open is the same. I am using Office 2003. |
numerical columns
Thank you for you quick reply. It worked!
"Pete_UK" wrote: Click on Tools | Options | General tab, then uncheck R1C1 Reference style. Hope this helps. Pete On Sep 23, 3:57 pm, Billie wrote: When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. Every work sheet that I open is the same. I am using Office 2003. |
numerical columns
Thank you for your quick reply. It worked!
"Niek Otten" wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
numerical columns
Thank you for your quick reply. It worked!
"Roger Govier" wrote: Hi Billie toolsoptionsgeneraluntick R1C1 reference style -- Regards Roger Govier "Billie" wrote in message ... When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. Every work sheet that I open is the same. I am using Office 2003. |
numerical columns
Thanks for the feedback, Billie - always appreciated.
Pete On Sep 23, 4:32*pm, Billie wrote: Thank you for you quick reply. *It worked! "Pete_UK" wrote: Click on Tools | Options | General tab, then uncheck R1C1 Reference style. Hope this helps. Pete On Sep 23, 3:57 pm, Billie wrote: When I open Excel, my column labels are numerical instead of alphabetical and I can't figure out how to change them back. *Every work sheet that I open is the same. I am using Office 2003.- Hide quoted text - - Show quoted text - |
numerical columns
A futher idea on this question: Can these Columns be edited to display a
desired text? "Niek Otten" wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
numerical columns
No. But you can Hide them and use Row 1 for your text
Jeff wrote: A futher idea on this question: Can these Columns be edited to display a desired text? "Niek Otten" wrote: ToolsOptionsGeneral tab, uncheck R1C1 reference style -- Kind regards, Niek Otten Microsoft MVP - Excel "Billie" wrote in message ... | When I open Excel, my column labels are numerical instead of alphabetical and | I can't figure out how to change them back. Every work sheet that I open is | the same. I am using Office 2003. |
All times are GMT +1. The time now is 08:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com