Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change excel column heading from numeric to alphabetic?
My spreadsheet column headings changed fom aphabetic to numeric. I would like
to know how to change them back to alphabetic. I just asked this question and received an answer. However the answer never appeared, just a blank page. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change excel column heading from numeric to alphabetic?
HI Again
Will try once moo GotoToolsOptionsGeneraluncheck R1C1 reference style. HTH John "bones21" wrote in message ... My spreadsheet column headings changed fom aphabetic to numeric. I would like to know how to change them back to alphabetic. I just asked this question and received an answer. However the answer never appeared, just a blank page. |
#3
|
|||
|
|||
Please follow the following steps
1.From the toolbar select tooloptions 2.In the Options dialog box, select the tab titled "General" 3.From the setting, remove the check mark from the option 'R1C1 Reference style' 4.Then click OK Now, You are done ! Have a happy time Chris ------ Convert your Excel spreadsheet into online calculator. http://www.spreadsheetconverter.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change excel column heading from numeric to alphabetic?
Hi,
In the menubar ToolsOptionsGeneralUncheck the R1C1 reference styleOK you will get the column headings back in alphabetical order. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "bones21" wrote: My spreadsheet column headings changed fom aphabetic to numeric. I would like to know how to change them back to alphabetic. I just asked this question and received an answer. However the answer never appeared, just a blank page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do change excel columns from alphabetic to numeric | Excel Discussion (Misc queries) | |||
how do I column heading to alpha from Numeric? | Excel Discussion (Misc queries) | |||
how do I convert column labels back to alphabetic from numeric? | Excel Discussion (Misc queries) | |||
how do I change column heading in excel (2007) | Excel Discussion (Misc queries) | |||
Column headings are numeric rather than alphabetic | Excel Discussion (Misc queries) |