Excel column headings
Posted by Holly on December 11, 2001 1:24 PM
My excel document had defaulted to numbers instead of ABC
I need to know how to change this.
Thanks
Holly
Posted by Holly on December 11, 2001 1:25 PM
Posted by Aladin Akyurek on December 11, 2001 1:27 PM
Hoolly --
Activate Tools|Options (Preferences on the Mac if applicable), uncheck R1C1 reference style on the General tab.
Aladin
=========
Posted by Holly on December 11, 2001 1:32 PM
This is on a pc
Posted by Holly on December 11, 2001 1:39 PM
thank You Aladin that worked.
Holly
Posted by Rick E on December 11, 2001 1:42 PM
For your PC, in Excel Select Tools, Options
then the General Tab, and un-select "R1C1 reference style".
Rick E
Posted by Jack on December 11, 2001 2:54 PM
Holly
Common question, sounds likeyou have turned on Row1Column1 (R1C1)format in Tool|Options its clicked ON so click OFF(thans no tick) to get back to ABC 123 Format we all like
Change is instant, HTH
