Excel Column Headings

J

JF

I am using Excel 2002 and I just noticed after my last
software update that all the column headings ar now
numbers like the rows and the calculations are based on
the columns and rows being numbers e.g. cell A1 is now
R1C1, A2 is now R2C1, etc.. How do I get the Alpha
characters back?
 
E

Eva Shanley

Tools - Options - General tab, uncheck R1C1 reference
style; that should do it for you.
 

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

Excel Column Headings Numeric to Alpha 1
Column headings are numbers instead Alphabet Letters 3
Column Headings 1
How do I change column addresses from numeric to alpha? 1
Excel 2007 change column labels from numbers to letters 8
Column headings display as a numbers 7
view Excel row & col headings in a large font size e.g. Arila 20 p 1
Excel Row & Column question 1

Top