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
how can i change the letters in the top row to words 0
what could cause numbers to appear as row names and column names 2
How do I get Excel column headings to be letters not numbers? 3
How to rename the head A,B,C,D,E etc. on every column 0
columns and rows labeled the same (cell 1-1 vs a-1) how do I chang 6
How do I change headings (column name) from numbers to letters? 2
Column heading is numeric. How to change to Alphabet? 1

Top