Board logo

Really easy excell question
Alan B - 15/9/13 at 01:09 PM

That is, easy, for those who know.....

Q:
My columns used be labelled as letters, now they are numbered.
No idea how it changed and would like it back how it was.

Cheers Alan


MikeRJ - 15/9/13 at 01:18 PM

You have the "R1C1 reference style" enabled. If you have 2010 then it's in File|Options|Formulas, but I can't remember where it is on earlier versions.


Alan B - 15/9/13 at 01:20 PM

This was it....

Cheers

Damn, this site is good....


teegray19 - 15/9/13 at 01:20 PM

Right click on columb, format cells then letters