L
lazybee
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
letters. How can I change this back to letters?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
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
There, uncheck the R1C1 reference style setting.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
T
Trevor Shuttleworth
Tools | Options | General tab | select R1C1 reference style
Regards
Trevor
Regards
Trevor
R
rockohead
This Is why the internet rules...I can get some sleep now! Thank You.
M
Maxim
For Excel 2007 this option is available here:
Excel Options/Formulas/R1C1 Reference style
Excel Options/Formulas/R1C1 Reference style