how to mention rows in alphetical format instea dof numbers

[Sampath Srinivasan]

My excel worksheets indicate columns in numbers instead of the traditional
alphabets. How do I revert back to the default of indicating columns as
alphabets A, B C

 

[Roger Govier]

Hi

Tools>Options>General>uncheck R1C1 notation

--
Regards
Roger Govier

My excel worksheets indicate columns in numbers instead of the traditional
alphabets. How do I revert back to the default of indicating columns as
alphabets A, B C

__________ Information from ESET Smart Security, version of virus
signature database 4511 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4511 (20091015) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gord Dibben]

Excel 2003 Tools>Options>General.

Uncheck R1C1 cell reference.

Excel 2007 Button>Excel Options>Formulas>Working with formulas.

Uncheck same as above,


Gord Dibben MS Excel MVP


On Thu, 15 Oct 2009 09:11:48 -0700, Sampath Srinivasan <Sampath