click on the multi-colored button on top left, then click Excel Options on
bottom. go to general tab and uncheck R1C1 reference style.

"User13" wrote:

I received a spreadsheet of mine back from a coworker, and all my formulas
now look like =Totals!R[3]C[-1] instead of what I originally used =TOTALS!C73.

Anyone know why this changed, and how to change them back?
--
User13