MS Excel Column Headers Naming

  • Thread starter Jeff Winterstein
  • 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!
 
Ad

Advertisements

T

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.
 
Ad

Advertisements

Joined
Nov 7, 2009
Messages
1
Reaction score
0
I need to change the column headers back to alpha (from numeric).

How do you do this in Excel 2007?

thanks!
germanyj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top