Why are my excel worksheet columns are Numbered not Alpha

G

Guest

My excel worksheet columns are numbered not alpha. What did I do? How can I
change back to numbers
 
N

Norman Jones

Hi Paula,

Try:

Tools | Options | General Tab | deselect 'R1C1 reference style | ok
 
G

Guest

You've probably set the R1C1 referencing style.

Go to Tools>Options> then selecet the General Tab and uncheck the R1C1 box
in the Settings section.
 

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

Row and columns 3
My Excel columns are now denoted with numbers not letters, why? 1
How do i change column header from R[1] C format to A1 format? 4
Column and Row Labels 1
Excel columns are now numbered instead of lettered 4
Displaying column and row names 3
Why are my Excel columns numbered and not alphabetized (A..ZZ)? 2
Excel 2007 Reference Style 1

Top