View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.