HELP - all formulas turned relative

X

xexex

so instead of a having colums A, B, C etc, I now have 1, 2, 3, 4
instead.

Instead of showing formulas as "=B1+A1" I now have =R[-2]C+R[-1]C
help!!!!!!!!!!!!!!!!!!!!!!!!
 
S

Sandy Mann

Tools > Options > General > uncheck R1C1 reference style

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top