Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Data to Appear as Column Headings in Another Sheet | Excel Discussion (Misc queries) | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
Using an Index by Column Headings instead of Column Numbers | New Users to Excel | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |