How do I change column identifiers from numbers to letters?

G

Guest

My excel columns somehow reverted to numbers instead of letters. How can I
change the format back to letters?
 
H

hideki

Go to Tools -> Options... -> General tab
Unselect the setting that contains R1C1... Normally at the upper left
(Sorry I couldn't found the exact word because I'm using non-Englis
version
 
S

swatsp0p

Hideki is correct. On the General Tab, under "Settings" uncheck th
"R1C1 Reference style" box
 

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

Columns now numbers rather than letters how do i get letters back 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns are numbers instead of letters 4
Column header format 5
Changing grey column headings from numbers back to capital letters 2
How do I change Excel column cell identifiers back to letters? 4
How do I convert numbered columns to lettered columns? 1
Excel 2007... fix column headings from numbers back to letters 4

Top