ExcelBanter - Excel help should explain how to change r1c1 to a1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel help should explain how to change r1c1 to a1 (https://www.excelbanter.com/excel-discussion-misc-queries/10151-excel-help-should-explain-how-change-r1c1-a1.html)

schlimgen

Excel help should explain how to change r1c1 to a1

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

Peo Sjoblom

toolsoptionsgeneral and uncheck/check R1C1 reference style

--
Regards,

Peo Sjoblom

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

"schlimgen" wrote in message
...
Help describes a1 and r1c1 referencing but doesn't tell how to switch from
one to the other. Can anyone help?

Otto Moehrbach

Click on Tools - Options - General tab. Check/Uncheck R1C1 reference style.
HTH Otto
"schlimgen" wrote in message
...
Help describes a1 and r1c1 referencing but doesn't tell how to switch from
one to the other. Can anyone help?

All times are GMT +1. The time now is 07:40 PM.