Excel help should explain how to change r1c1 to a1

S

schlimgen

Help describes a1 and r1c1 referencing but doesn't tell how to switch from
one to the other. Can anyone help?
 
P

Peo Sjoblom

tools>options>general and uncheck/check R1C1 reference style

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
O

Otto Moehrbach

Click on Tools - Options - General tab. Check/Uncheck R1C1 reference style.
HTH Otto
 
Top