View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.