How can I change column numbers to alphabetical letters (Excel)

  • Thread starter Thread starter Gustav
  • Start date Start date
G

Gustav

My current Excel sheet (XP 2007) have numerical numbers for columns eg. C1
or C5.
In Office 2003 this was Column A or column E
 
Hello Gustav

Go Office button>Excel Options>Formulas and uncheck "R1C1 Reference Style"

Richard
 
Try (from a few hours earlier in this newsgroup):
Click the Office button
Excel Options>Formulas>Working with formulas>uncheck R1C1 reference style>OK
 
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
How: reset the column headings from numeric to alphabetic? 1
Cells display as R5C5. How do I change it to display E5? 2
How do change excel columns from alphabetic to numeric 1
columns showing numbers instead of alphabets 1
Help to create a macro 2
numerical columns 8
how do i change column numbers to alphabets from numerals 2

Back
Top