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

I have no idea how it happened, but every time I open a new Excel
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 enter
formulas since referring to a cell as "A1", for example, no longer
works.

Thanks!


--
charry47
------------------------------------------------------------------------
charry47's Profile: http://www.excelforum.com/member.php...o&userid=36636
View this thread: http://www.excelforum.com/showthread...hreadid=563864

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

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563864

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

Go to Tools, Click the "General" tab and uncheck "R1C1 reference style"

"charry47" wrote:


I have no idea how it happened, but every time I open a new Excel
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 enter
formulas since referring to a cell as "A1", for example, no longer
works.

Thanks!


--
charry47
------------------------------------------------------------------------
charry47's Profile: http://www.excelforum.com/member.php...o&userid=36636
View this thread: http://www.excelforum.com/showthread...hreadid=563864

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

Thank you both very much! I went and unchecked the box and all is back
to normal.


--
charry47
------------------------------------------------------------------------
charry47's Profile: http://www.excelforum.com/member.php...o&userid=36636
View this thread: http://www.excelforum.com/showthread...hreadid=563864