Excel, how do I change the column headings from letters to number
 

I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"lazybee" wrote in message
...
I have a spreadsheet that has numbered columns as opposed to the
standard
letters. How can I change this back to letters?

Tools | Options | General tab | select R1C1 reference style

Regards

Trevor


"lazybee" wrote in message
...
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?

Excel, how do I change the column headings from letters to num
 

This Is why the internet rules...I can get some sleep now! Thank You.

"Trevor Shuttleworth" wrote:

Tools | Options | General tab | select R1C1 reference style

Regards

Trevor


"lazybee" wrote in message
...
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?

Excel, how do I change the column headings from letters to number
 

For Excel 2007 this option is available he

Excel Options/Formulas/R1C1 Reference style

"lazybee" wrote:

I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?