MS Excel Column Headers Naming

[Jeff Winterstein]

I have MS Office 97 and my Excel file(s) have numbers in
the columns and rows and not letters in the columns. How
do I cahnge it to have letters and numbers and not have
numbers and numbers?

Please advise.

Thanks!

 

[Tom]

-----Original Message-----
I have MS Office 97 and my Excel file(s) have numbers in
the columns and rows and not letters in the columns. How
do I cahnge it to have letters and numbers and not have
numbers and numbers?

Please advise.

Thanks!
.
Jeff,

Go to Tools/Options and click the General Tab. In
the "Settings" area, unclick the "R1C1 reference style",
then click OK. That should do it.

 

[germanyj]

I need to change the column headers back to alpha (from numeric).

How do you do this in Excel 2007?

thanks!
germanyj