change column names to letters

  • Thread starter Thread starter Raimundas Dundulis
  • Start date Start date
R

Raimundas Dundulis

Normally column headers have names using letters and row
header has names using numerals. In my excel numerals are
used to define both columns & rows headers.
Normally you have A1 cell, and I have R1C1.
How can I change to normal headers, so that Columns header
would consist of letters, and rows header consist of
numerals?

Thank you very much.
 
Tools>Options>General, uncheck R1C1 Reference style

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top