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

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!

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

Probably this way:
Toolsoptionsgeneral deselect R1C1 reference style

Regards,
Fred

"cg-ksd" wrote in message
...
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!

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

hi
on the menu bartoolsoptionsgeneral tabuncheck R1C1 reference style.

Regards
FSt1

"cg-ksd" wrote:

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!

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

In case you're using Excel 2007

Office ButtonExcel OptionsFormulas.

Uncheck R1C1 notation.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 12:28:01 -0800, cg-ksd
wrote:

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!