|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 27th, 2009, 01:43 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell References: R[-2]C[0] vs A10
One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to R[x]C[y] references. How to I restore the default reference system??? Thanks 
|
|
#2
August 27th, 2009, 03:02 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell References: R[-2]C[0] vs A10
In Excel 2007:
Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "Arthur" wrote in message news  One of my excel spreadsheet suddenly replaced all of the "normal" Ax references to R[x]C[y] references. How to I restore the default reference system??? Thanks
|
|
#3
August 27th, 2009, 05:54 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell References: R[-2]C[0] vs A10
Thanks Biff, that did it.
Now, how that ever got turned on I don't have a clue. Well maybe, Excel did crash and the restored file came back that way. Thanks again. Arthur "T. Valko" wrote in message ... In Excel 2007: Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "Arthur" wrote in message news One of my excel spreadsheet suddenly replaced all of the "normal" Ax references to R[x]C[y] references. How to I restore the default reference system??? Thanks
|
|
#4
August 27th, 2009, 06:01 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell References: R[-2]C[0] vs A10
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Arthur" wrote in message ... Thanks Biff, that did it. Now, how that ever got turned on I don't have a clue. Well maybe, Excel did crash and the restored file came back that way. Thanks again. Arthur "T. Valko" wrote in message ... In Excel 2007: Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "Arthur" wrote in message news One of my excel spreadsheet suddenly replaced all of the "normal" Ax references to R[x]C[y] references. How to I restore the default reference system??? Thanks
|
|
#5
August 27th, 2009, 06:03 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Cell References: R[-2]C[0] vs A10
Excel picks up this setting from the first workbook you open in that session.
If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough to open a workbook that he saved as the first workbook in that session, you'll be making the same change again. So make a note of Biff's suggestion. And then start a reference style war at your place of business!!! Arthur wrote: Thanks Biff, that did it. Now, how that ever got turned on I don't have a clue. Well maybe, Excel did crash and the restored file came back that way. Thanks again. Arthur "T. Valko" wrote in message ... In Excel 2007: Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "Arthur" wrote in message news One of my excel spreadsheet suddenly replaced all of the "normal" Ax references to R[x]C[y] references. How to I restore the default reference system??? Thanks -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
