in excel, workbook column heading is displaying numbers not lette.

  • Thread starter Thread starter dawn
  • Start date Start date
D

dawn

in excel 2007 when i open up a new page i noticed that the top default
heading show number instead of letters. ex: horizontal should be numbers and
vertical should be letters
 
In Excel, click on Tools | Options | General tab | uncheck the
"R1C1 reference style" box | OK.
 
In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas

- make sure that there is no tick (check) in the box called:-

R1C1 reference style

If my comments have helped please hit Yes.

Thanks.
 
Back
Top