![]() |
Column grid headings
Hope somebody can help. For some reason the grid column headings on my xcel
spreadsheets changed from alpha (A,B,C etc) to numeric ( 1,2,3 etc.) So now both my column and row designations are numeric. I don't know how it changed and don't know how to change back. Can anybody help? Thanks! |
Paula, 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 "paula" wrote in message ... Hope somebody can help. For some reason the grid column headings on my xcel spreadsheets changed from alpha (A,B,C etc) to numeric ( 1,2,3 etc.) So now both my column and row designations are numeric. I don't know how it changed and don't know how to change back. Can anybody help? Thanks! |
Tools--Options, General tab. Uncheck R1C1 reference style.
************ Anne Troy www.OfficeArticles.com "paula" wrote in message ... Hope somebody can help. For some reason the grid column headings on my xcel spreadsheets changed from alpha (A,B,C etc) to numeric ( 1,2,3 etc.) So now both my column and row designations are numeric. I don't know how it changed and don't know how to change back. Can anybody help? Thanks! |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com