Row headings have changed from letters to numbers. How do I undo?

G

Guest

My Row headings in excel have changed from letters to numbers - making the
formulas complicated to look at, to say the least.

How do I change it back?

Even new blank worksheets have the numbers on instead of the letters.
 
G

Guest

open excell

goto tools then options

in the general tab , take out the tick from the R1C1 settings box

Rich
 

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 2007... fix column headings from numbers back to letters 4
How do I change headings (column name) from numbers to letters? 2
Changing grey column headings from numbers back to capital letters 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Column Heading Error 3
Column chngd fm letters to numbers. What that & how do I go back? 1
Column headings - urgent help needed please 3
Excel - Column headings 1

Top