ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Columns headings changed to numbers in all of my worksheets (https://www.excelbanter.com/new-users-excel/202884-columns-headings-changed-numbers-all-my-worksheets.html)

thunderhead

Columns headings changed to numbers in all of my worksheets
 
Recently, and I do not know how, all of the column headings in all of my
worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they are
supposed to be).

Any ideas on how I can change the default settings of Excel 2003 to give me
letters for the column headings again (preferably for all worksheets)? I much
prefer A1 as a reference to a specific cell than R1C1.

T. Valko

Columns headings changed to numbers in all of my worksheets
 
Goto the menu ToolsOptionsGeneral tabuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"thunderhead" wrote in message
...
Recently, and I do not know how, all of the column headings in all of my
worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they
are
supposed to be).

Any ideas on how I can change the default settings of Excel 2003 to give
me
letters for the column headings again (preferably for all worksheets)? I
much
prefer A1 as a reference to a specific cell than R1C1.





All times are GMT +1. The time now is 01:39 PM.

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