How do I change column labels from numbers to letters?

G

Guest

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.
 
P

Paul B

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
 
L

L. Howard Kittle

Hi Gregg,

Tools > Options > General > R1C1 reference style > uncheck > OK

HTH
Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change column labels back to letters? 1
column labels 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns now numbers rather than letters how do i get letters back 2
Column labels 4
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
Columns are numbers instead of letters 4
column headers changed from letters to numbers, how do I change ba 1

Top