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

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
 
R

Richard Schollar

Hello Gustav

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

Richard
 
D

David Biddulph

Try (from a few hours earlier in this newsgroup):
Click the Office button
Excel Options>Formulas>Working with formulas>uncheck R1C1 reference style>OK
 

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
column headers changed from letters to numbers, how do I change ba 1
numerical columns 8
Columns are numbers instead of letters 4
Column header format 5
Columns now numbers rather than letters how do i get letters back 2
How doo I add letters or numbers to a whole column of part #s 1
For Excel 2007 how do yu change column headers from numbers to let 1

Top