How do I change column headings fron numbers to letters in excell.

J

John

Hi Martin
In Excel 2003 and older goto > Tools>Options>Select General Tab>and unselect
R1C1 reference Style.
HTH
John
 
M

Martin C

Hi John
Thanks I run excell 2007 but with your ref to R1C1 reference Style I
managed to put things right
Many thanks
Martin
 
J

John

You're welcome, glad I could help.
John
Martin C said:
Hi John
Thanks I run excell 2007 but with your ref to R1C1 reference Style I
managed to put things right
Many thanks
Martin
Click to expand...
 

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

Columns headings changed to numbers in all of my worksheets 1
column header labels are numbered but need to be lettered 2
Row & Column Headings 2
Why are columns in some Excel files numbered instead of lettered? 1
How do I Change the Column Names (Re-Name A - 2
In Excel I now have numbers instead of letters on column tops 1
Excel 2007... fix column headings from numbers back to letters 4
Excel Convert word into numbers and back 4

Top