How to Switch between A1 and R1C1 Reference Style in Excel?
In the last post on reference style in Excel, I discussed about A1 and R1C1 reference style. Sometimes its necessary to switch between these two reference style for easy usage, but how to change between A1 and R1C1 reference style?
This option is different in Office 2003 and in Office 2007.
In Office 2003, go to Tools -> Options.
Click on the General Tab.
Under the settings, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.
In Office 2007, Click the Office button and click Excel Options which you will find at the end near Exit Excel.
Go to Formulas tab and under Working with formulas, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.
Enjoyed this post? We write daily tips, tricks and tweaks for Office Excel, Word, Powerpoint, Outlook, Windows and other applications. Get 100% free daily updates on 
This is what I’m looking for. Free traffic. Thanks for helpful information
[...] For human computation and understanding A1 reference style is better but if you are writing a macro, then R1C1 reference style would be better to compute with referencing to the positions. If you are writing a macro but you don’t want to get confused then you may switch to A1 reference style and write all the formulas and then switch back to R1C1 reference style to get the value of the formulas in this reference style. (Read more on: How to switch between A1 and R1C1 Reference Style in Excel?) [...]
Concise and clear answer. Super helpful. Thanks
Thx
Mr Byte.
It`s on your way but U can`t find it:)
Hi,
Any idea how to switch between A1 and R1C1 Reference Style in Windows Vista?
Kevin
Thnx for solving with office 2007!!! respect!
thank you thank you for figuring this out in Excel 07 - I was losing my mind!!
thanks a lot ! its very usefull ^_^