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. |
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. |
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. |
All times are GMT +1. The time now is 02:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com