Example I: Enter formula “=A1/B1” in C1 cell, copy it and paste to C2 cell, formula will automatically update to “=A2/B2”.
Example II: Enter formula “=total(A)” in C1 cell, copy it and paset to D1 cell, formula will automatically update to “=total(B)”.