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

  • Thread starter Thread starter Ahmad Sanad
  • Start date Start date
A

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
 
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
 
Click the Office button -- upper left
Excel options
Formulas
Uncheck R1C1 reference style
 
Back
Top