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

  • Thread starter Thread starter cg-ksd
  • Start date Start date
C

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!
 
In case you're using Excel 2007

Office Button>Excel Options>Formulas.

Uncheck R1C1 notation.


Gord Dibben MS Excel MVP
 
Back
Top