| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can change column title back to alphabet (A,B,C..)
In my worksheet the column title are numbers (1,2,3....) and I would like to
change back to alphabetic (A,B,C...). Can some one help my. Thank you very much. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can change column title back to alphabet (A,B,C..)
Ray, tools, options, general, uncheck R1C1 reference style
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ray" wrote in message ... In my worksheet the column title are numbers (1,2,3....) and I would like to change back to alphabetic (A,B,C...). Can some one help my. Thank you very much. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can change column title back to alphabet (A,B,C..)
From the menu bar, Tools Options, click General, deselect 'R1C1 reference
style' and click OK. (If it's already deselected, try to select, then OK, then deselect and OK). "Ray" wrote: In my worksheet the column title are numbers (1,2,3....) and I would like to change back to alphabetic (A,B,C...). Can some one help my. Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nedd to change column headings from numbers back to letters | New Users to Excel | |||
| How do I change the Excel Column Labels as back to alpha? | Excel Discussion (Misc queries) | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) | |||
| how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
Hybrid Mode
