Row/Column Names
 

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

Row/Column Names
 

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


In article ,
Nadine wrote:

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.

Row/Column Names
 

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

Row/Column Names
 

Thanks, hadn't see that before.

"JE McGimpsey" wrote:

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


In article ,
Nadine wrote:

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.