format Column with horizontal alphabet label

  • Thread starter Thread starter Raymond Chang
  • Start date Start date
R

Raymond Chang

I using Microsoft Excel 2003 SP2, I have this problem when I opened new
spreadsheet, the horizontal column appear as number e.g 1,2,3 ----
Default should be a alphabet label.

Existing spreadsheet is OK, horizontal column appear as alphabet label and
vertical row appear as number label.

Is there any special setting to be done on MS Excel?

Regards!
Raymond Chang
 
Raymond

Tools>Options>View tab and uncheck "R1C1 reference style" should put you
back on track.

Mike Rogers
 
Hi Raymond

goto Tools --> Options --> General

and uncheck "R1C1 Reference Style"

that should do the trick.

hth
Carlo
 
Hi Raymond,

Try this when you open a new excel workbook or you find such a setting in
the existing workbook you can simply go to.

Menubar/Tools/Options/General Tab/Uncheck R1C1 Reference style.

This will enable the columns to have alphabets instead of 1,2,3...

Thanks
 
Back
Top