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?
To switch back, go to Excel Options > Formulas and uncheck the below option:
Hope that helps