Alan B
|
| posted on 15/9/13 at 01:09 PM |
|
|
Really easy excell question
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
|
| posted on 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
|
| posted on 15/9/13 at 01:20 PM |
|
|
This was it....
Cheers
Damn, this site is good....
|
|
|
teegray19
|
| posted on 15/9/13 at 01:20 PM |
|
|
Right click on columb, format cells then letters
|
|
|
