ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column grid headings (https://www.excelbanter.com/excel-discussion-misc-queries/46912-column-grid-headings.html)

paula

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!

Paul B

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!




Anne Troy

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