Excel shows numbered column headers.

M

Mike Blum

My spreadsheet shows numbered row headers and numbered column headers. I
want to change the column headers to letters but do not know how. Need help
please. Thanks.
 
F

FSt1

hi
on the menu bar...
Tools>options>general tab>uncheck R1C1 reference style

Regards
FSt1
 
G

Gord Dibben

Excel 2003 and earlier.

Tools>Options>General. Uncheck "R1C1 Reference Style"


Gord Dibben MS Excel MVP
 
M

Mike Blum

Thank you very much for the help. Mike

Gord Dibben said:
Excel 2003 and earlier.

Tools>Options>General. Uncheck "R1C1 Reference Style"


Gord Dibben MS Excel MVP
Click to expand...
 
Top