ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why are my column headings numerical instead of alphabetical? (https://www.excelbanter.com/excel-discussion-misc-queries/44548-why-my-column-headings-numerical-instead-alphabetical.html)

raken

Why are my column headings numerical instead of alphabetical?
 
Microsoft Excel 2003
The column and row headings in my excel spreadsheet are both numerical. Cell
references are in the form of R1C1, R2C2 instead of the usual A1, B2, etc.
How do I change my column headings back to the alphabetical format?

Ron Rosenfeld

On Thu, 8 Sep 2005 20:14:01 -0700, "raken"
wrote:

Microsoft Excel 2003
The column and row headings in my excel spreadsheet are both numerical. Cell
references are in the form of R1C1, R2C2 instead of the usual A1, B2, etc.
How do I change my column headings back to the alphabetical format?


Tools/Options/General/Settings and DEselect R1C1 Reference style


--ron


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com