In Excel the colums which used to be A,B,C D etc are now 1,2,3

Dave Lock · May 9, 2006

Why is this, and how can I change it back to A,B,C etc

SVC · May 9, 2006

Tools > Options, on the General tab uncheck R1C1 reference style.

Daniel CHEN · May 9, 2006

Go to menu: Tools>Options>General> Uncheck "R1C1 Reference Style"

--
Best regards,
---
Yongjun CHEN
Vice President, CAPST
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

David Biddulph · May 9, 2006

Dave Lock said:
Why is this, and how can I change it back to A,B,C etc

Tools/ Options/ General
Unset "R1C1 reference style"

In Excel the colums which used to be A,B,C D etc are now 1,2,3

Dave Lock

SVC

Daniel CHEN

David Biddulph