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

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!

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

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.



"SalExcel10" wrote:

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!

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

toolsoptionsgeneralr1c1


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SalExcel10" wrote in message
...
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!