Row/Column Names

[Nadine]

Got a strange one hadn't seen before.

Rows show as 1,2,3,
but columns showing as 1, 2, 3.... not A, B, C, D

Can't figure out how to out back as A, B, C, D.....

How does that happen, is this a feature where you can change it, if so how?
Good to know for future references, and if did change how to change it back.

Thanks

 

[JE McGimpsey]

Tools/Options/General - uncheck the "Use R1C1 reference style" checkbox.

 

[Alan]

On the toolbar, go 'Tool's > 'Options', click the 'General' tab and uncheck
'R1C1 Reference Style'.
Don't ask me how it got changed, it seems to happen occasionally for no
apparent reason!
Regards,
Alan.

 

[Nadine]

Thanks, hadn't see that before.

Tools/Options/General - uncheck the "Use R1C1 reference style" checkbox.