MS Excel Copy Formula Tutorial
MS Excel Copying formulas is one of the most common tasks you perform in a typical spreadsheet that relies primarily on formulas.
When a formula uses cell references instead of constant values, Excel copies the original formula everywhere it needs a similar formula.
Relative unit address
MS Excel automatically adjusts the cell references in the original formula to fit the position of the copy you make. It does this through a system called relative cell addresses, where column references in cell addresses in formulas change to accommodate their new column positions, and row references change to accommodate their new row positions.
Let’s see this with the help of an example. Suppose we want the sum of all the rows at the end, then we will write a formula for the first column, which is B. We want the sum of the rows from 3 to 8 in row 9.
After writing the formula in row 9, we can drag it to the remaining columns and copy the formula. After dragging, we can see the formula in the remaining columns as shown below.
Column C: =SUM(C3:C8)
Column D: =SUM(D3:D8)
Column E: =SUM(E3:E8)
Column F: =SUM(F3:F8)
Column G: =SUM(G3:G8)
Related:
Money Management Excel Sheet Template