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

Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0
Booklet in Word, Merge Directory from Excel 0
Column headings are numbers instead Alphabet Letters 1
Need help merging Excel into Publisher Booklet w 2 columns 0
Disabling auto-numbering in headings when converting PDF to Word 0
Cell data entering slow! 0
Dates In Excel 5

Top