Excel, how do I change the column headings from letters to number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
 
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Tools | Options | General tab | select R1C1 reference style

Regards

Trevor
 
This Is why the internet rules...I can get some sleep now! Thank You.
 
For Excel 2007 this option is available here:

Excel Options/Formulas/R1C1 Reference style
 
You must log in or register to reply here.

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

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel 2007... fix column headings from numbers back to letters 4
why have my column headings changed to numbers 1
Column headings 2
Changing grey column headings from numbers back to capital letters 2
Column Heading 1
changing column letters to numbers , etc. 3
Column Heading Error 3

Back
Top