Excel Columns showing numbers 1

[darude]

Hi All,
I'm hoping this is a simple question. When I open a new excel workbook the columns have number values rather than letters. Does anyone know what switches that on, and how do I switch it off. Any help would be most appreciated!

 

[AnotherHiggins]

Go to Tools > Options > General and uncheck R1C1 Reference Style.

Voila

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[darude]

That's it! Thank you very much.

 

[Speedle]

Yeah. I had this problem too. It’s good when there are people that always can help!!!!
)

 

[AnotherHiggins]

Glad I was able to help not one, but two people with my reply.

Thanks for the "thanks", Speedle.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[firefytr]

To thank John for his valuable post, you should click on the link (on the bottom left of each post) which says, "Thank UserName for this valuable post!" (I have done this here.)

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci