Help, my column headings have turned from letters into numbers!

  • Thread starter Thread starter charry47
  • Start date Start date
C

charry47

I have no idea how it happened, but every time I open a new Exce
spreadsheet all of my column headings are numbers instead of letters.
How do I turn it back? It's making it very confusing for me to ente
formulas since referring to a cell as "A1", for example, no longe
works.

Thanks
 
go to tools, options, general, is the R1C1 boc ticked? if it is untick
it!

Regards

Dav
 
Go to Tools, Click the "General" tab and uncheck "R1C1 reference style"
 
Thank you both very much! I went and unchecked the box and all is back
to normal.
 
You must log in or register to reply here.

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

why have my column headings changed to numbers 1
Column Heading Error 3
Column Heading 1
Excel 2007... fix column headings from numbers back to letters 4
column headings 3
Column headings 2
Creating sequential numbers plus a letter 4
1st Row Column Heading as column letter 6

Back
Top