Apr 10 2019 07:42 PM - last edited on Nov 09 2023 11:10 AM by
Apr 10 2019 07:42 PM - last edited on Nov 09 2023 11:10 AM by
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?
Apr 10 2019 08:19 PM
To switch back, go to Excel Options > Formulas and uncheck the below option:
Hope that helps