Cell References: R[-2]C[0] vs A10

  • Thread starter Thread starter Arthur
  • Start date Start date
A

Arthur

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
 
In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK
 
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 said:
In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK

--
Biff
Microsoft Excel MVP


Arthur said:
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
Click to expand...
Click to expand...
 
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Arthur said:
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 said:
In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK

--
Biff
Microsoft Excel MVP


Arthur said:
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
Click to expand...
Click to expand...
Click to expand...
 
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!!!
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 said:
In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK

--
Biff
Microsoft Excel MVP


Arthur said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top