Columns now numbers rather than letters how do i get letters back

S

SalExcel10

Somehow I have managed to accidentally change the column references to
numbers rather than letters. How do I get these back? Not sure of the correct
terminology but I am referring to where the rows are usually numbers and the
columns usually letters. My columns are now also numbers!
 
T

trip_to_tokyo

In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas

- make sure that there is no tick in the box called:-

R1C1 reference style

EXCEL 2003

Tools / Options / General tab – remove tick from R1C1 Reference style.

If my comments have helped please hit Yes.

Thanks.
 

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

Setting column width in a table with a macro is not working 0
Columns are numbers instead of letters 4
Changing grey column headings from numbers back to capital letters 2
How can the font and size of (all) citation numbers be altered? 1
Why are my Columns labeled with Numbers rather than letters? 1
Columns are Numbers 5
2007, excel column hdings are now numbered - how do I get letters 1
columns 1

Top