A formula =A1+B2 is in cell D8. If you copy that formula to cell D9,
new formula in D9=A2+B3
Trust me on this. the value will increase by one for all the cells Please appreciate my help, by selecting my answer as the best, and add me as your tutor, Thanks!