L lsg Oct 21, 2009 #1 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.)
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.)
M Michael Arch Oct 21, 2009 #2 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.
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.
G Glenn Oct 21, 2009 #3 lsg said: 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.) Click to expand... Tool / Options / General / R1C1 reference style (un-check)
lsg said: 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.) Click to expand... Tool / Options / General / R1C1 reference style (un-check)
R Roger Govier Oct 21, 2009 #4 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 lsg said: 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 Click to expand... __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com
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 lsg said: 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 Click to expand... __________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________ The message was checked by ESET Smart Security. http://www.eset.com
