Forum Discussion
Cell Reference in Formula
Previous Excel function =sum(A1:A5)
New Excel 365 function =SUM(R[-5]C:R[-1]C). This is very confucing to me.
How do I switch back to previous cell adressing in Formula bar?
1 Reply
To switch back, go to Excel Options > Formulas and uncheck the below option:
Hope that helps
