Excel using =RC[-1] format and I don't want it

  • Thread starter Thread starter Just_a_fan
  • Start date Start date
J

Just_a_fan

On this machine only, Excel will use the format =RC[-1] when I am
entering a formula on the command line by hand and click on a cell to
reference it in the formula.

I don't know how this got on but I would like it to go off. On my other
machines, it does the old familiar A1:B2 style of cell reference.

I can't even search for how to fix it since I can't determine what this
is called so I can turn it off. The only reference I have seen is a
button that is only effective for macro creating and I am not creating a
macro, just a formula, interactively, in the cell.

How do I get this off?

Thanks,
Mike Morrow
 
Check this setting:

In Excel 2007:

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

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK out
 
Yup, that does it. Can't figure out how that got on but now it is off.

Thanks for the very speedy answer!!

Mike
 
Back
Top