Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Columns showing numbers 1

Status
Not open for further replies.

darude

Programmer
Joined
Jun 23, 2003
Messages
138
Location
US
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!
 
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.
 
That's it! Thank you very much.
 
Yeah. I had this problem too. It’s good when there are people that always can help!!!!
:))
 
[cheers]

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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top