MS Excel Column Headers Naming

  • Thread starter Thread starter Jeff Winterstein
  • Start date Start date
J

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!
 
-----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,
Click to expand...

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.
 
I need to change the column headers back to alpha (from numeric).

How do you do this in Excel 2007?

thanks!
germanyj
 
Back
Top