Excel sheet with numbers as column & row headers - How?

[cg-ksd]

I received an excel spreadsheet that has numbers as column headers (instead
of letters) and numbers as row headers. How do you change the headers for
the columns and rows. I always thought they were set. I have looked and
looked and can't find any information on this. Thanks!

 

[Fred Smith]

Probably this way:
Tools>options>general deselect R1C1 reference style

Regards,
Fred

 

[FSt1]

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

Regards
FSt1

 

[Gord Dibben]

In case you're using Excel 2007

Office Button>Excel Options>Formulas.

Uncheck R1C1 notation.


Gord Dibben MS Excel MVP