change column name from 1 2 3 to A B C in Excel 2007

[Ahmad Sanad]

Hi All

when I open new Excel file the column name is 1 2 3 and the Row name als 1 2
3 how can I chane back the column name to A B C

Many thanks
Ahmad

 

[Dave Curtis]

Hi,

In Excel2003 and earlier, go to Tools>Options>General and uncheck the R1C1
box.

In Excel2007, you'll have to wait for someone else to comment.

Dave

 

[AnotherNewGuy]

Click the Office button -- upper left
Excel options
Formulas
Uncheck R1C1 reference style