Columns in Excel are numbers instead of letters, how do I change .

B

barnes76

Recently when I open Excel, both the rows and columns are numbers. They are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine. The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.
 
B

Bob Phillips

Go to Tools>Options and on the General tab, uncheck the R1C1 Reference Style
checkbox.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Excel does not accept text format! 0
Column headers numbers instead of letters 2
Columns are numbers instead of letters 4
How can I change column designation from number to letters? 3
Excel sheet with numbers as column & row headers - How? 3
Columns now numbers rather than letters how do i get letters back 2
How do I change default cell referencing in excel from R1C1 to A1? 1

Top