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

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

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

Hi,

In Excel2003 and earlier, go to ToolsOptionsGeneral and uncheck the R1C1
box.

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

Dave

"Ahmad Sanad" wrote:

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

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

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

"Ahmad Sanad" wrote:

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