Dear Friends, Im using Excel 2002. Something happened to my excel. The A1B1 is showing as R1C1 system. I want to change that back to A1B1. How do I change that?
Thanks in Advance.
Nitin
+1
A:
Your formulas have simply switched to the R(ow)/C(olumn) style.
I have no Excel 2002 installation present but in 2003 you can change the setting through: Tools->Options->General and unchecking the R1C1 Reference Style.
Based on the Screenshots on jegsworks.com this should also work for Excel 2002.
The Microsoft Knowledge Base Article regarding the R1C1 Format also confirms that you should be able to access Options Through your Tools menu (apparently this goes even back to Excel 97).
marg
2010-09-02 09:21:52
Thanks for the reply. But the thing is I dont have "Options" under the "tools" menu. What can i do?
Nitin
2010-09-02 09:41:08
Thats weird. See my edit above. You should be able to access Options through Tools. Are you sure the Menu elements aren't hidden?
marg
2010-09-02 09:55:28
Sometimes, rarely used menu options are hidden. There might be a little double-down-chevron at the bottom of the menu. Click that and the menu will expand to its fullest, allowing you to choose "Options".
Delan Azabani
2010-09-02 09:55:44