ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numerical columns (https://www.excelbanter.com/excel-discussion-misc-queries/203556-numerical-columns.html)

Billie

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.

Niek Otten

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.



Pete_UK

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.



Billie

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.




Billie

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.




Billie

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.



Pete_UK

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 -



Jeff

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.




Bob I

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