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

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!
 
F

Fred Smith

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

Regards,
Fred
 
F

FSt1

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

Regards
FSt1
 
G

Gord Dibben

In case you're using Excel 2007

Office Button>Excel Options>Formulas.

Uncheck R1C1 notation.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Colunmn headers 4
Column header format 5
column headers changed from letters to numbers, how do I change ba 1
Column Headers 1
Why did my Excel column headers change from letters to numbers? 4
Excel shows numbered column headers. 4
For Excel 2007 how do yu change column headers from numbers to let 1
Change Excel column headers from numbers to letters 1

Top