Excel shows numbered column headers.

[Guest]

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.

 

[Guest]

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

Regards
FSt1

 

[Gord Dibben]

Excel 2003 and earlier.

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


Gord Dibben MS Excel MVP

 

[Guest]

That did the trick. Thank you very much for your help.

 

[Guest]

Thank you very much for the help. Mike

Excel 2003 and earlier.

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


Gord Dibben MS Excel MVP