HELP - all formulas turned relative

  • Thread starter Thread starter xexex
  • Start date Start date
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!!!!!!!!!!!!!!!!!!!!!!!!
 
Tools > Options > General > uncheck R1C1 reference style

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top