Thread: I'd like to change my column markers from numbers to letters
View Single Post
  #2  
Old May 17th, 2009, 05:43 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
  
Posts: 15,759
Default I'd like to change my column markers from numbers to letters
Goto ToolsOptionsGeneral tabuncheck R1C1 reference styleOK


Excel 2007: Office buttonExcel OptionsFormulasuncheck R1C1 reference
styleOK

--
Biff
Microsoft Excel MVP


"Excellence" wrote in message
...
Worksheet columns are labeled with numbers, making formulas very difficult
to
follow (=R[-5]C*R[-6]C[11]) instead of (B13*M7). Thanks for help.