Column Headings

[lsg]

My column headings show numeric numbers instead of alpha. How do I change
the heading bar back to alpha (A,B,C,D....AA,AB, etc.)

 

[Michael Arch]

From the Main Menu Select:
Tools->Options
Click on the "General" Tab and remove the check mark from the box that reads:
"R1C1 Reference Style"

--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.

 

[Glenn]

My column headings show numeric numbers instead of alpha. How do I change
the heading bar back to alpha (A,B,C,D....AA,AB, etc.)

Tool / Options / General / R1C1 reference style (un-check)

 

[David Biddulph]

Tools/ Options/ General
Unset R1C1 reference style.

 

[Roger Govier]

Hi

Just in case you are using XL2007, the method would be
Round Office button>Excel options>Formulas>Working with formulas>uncheck
R1C1 reference style

--
Regards
Roger Govier

My column headings show numeric numbers instead of alpha. How do I change
the heading bar back to alpha (A,B,C,D....AA,AB, etc.)

__________ Information from ESET Smart Security, version of virus
signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com