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.













1 Response to “How to Switch between A1 and R1C1 Reference Style in Excel?”