Excel shows numbered column headers.

G

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.
 
G

Guest

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

Regards
FSt1
 
G

Gord Dibben

Excel 2003 and earlier.

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


Gord Dibben MS Excel MVP
 
G

Guest

Thank you very much for the help. Mike

Gord Dibben said:
Excel 2003 and earlier.

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


Gord Dibben MS Excel MVP
Click to expand...
 

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
Excel 2003 column headings changed to numbers? want letters back 3
Excel sheet with numbers as column & row headers - How? 3
Clicking on numbered boxes, plus and minus sign to show and hide d 1
column headers 4
How pull ID#s that meet specific "yes" requirements 3
Power Pivot Variance Column 0
change column name from letters to numbers? 2

Top