![]() |
Column Headings
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.) |
Column Headings
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. "lsg" wrote: 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.) |
Column Headings
lsg wrote:
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) |
Column Headings
Tools/ Options/ General
Unset R1C1 reference style. -- David Biddulph lsg wrote: 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.) |
Column Headings
Hi
Just in case you are using XL2007, the method would be Round Office buttonExcel optionsFormulasWorking with formulasuncheck R1C1 reference style -- Regards Roger Govier "lsg" wrote in message ... 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 |
All times are GMT +1. The time now is 07:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com