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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change default cell referencing in excel from R1C1 to A1? 1
R1C1 reference style as default while opening Excel 3
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 3
r1c1 reference style - how to make it default 4
How do I change Excel columns from alphabetical to numeric? 5
How can I change column titles back to numbers? 4
R1C1 problems - Can't change 16
How can I change column designation from number to letters? 3

Top