I'd like to change my column markers from numbers to letters

  • Thread starter Thread starter Excellence
  • Start date Start date
E

Excellence

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.
 
Goto Tools>Options>General tab>uncheck R1C1 reference style>OK


Excel 2007: Office button>Excel Options>Formulas>uncheck R1C1 reference
style>OK
 
Goto Tools>Options>General tab>uncheck R1C1 reference style>OK


Excel 2007: Office button>Excel Options>Formulas>uncheck R1C1 reference
style>OK
 
Back
Top