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.

Excel copy formula

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)

Excel copy formula

Related:

Money Management Excel Sheet Template

Home Mortgage Loan Excel Calculation Template

Gantt Chart Template for Excel

Leave a Reply

Your email address will not be published. Required fields are marked *