Copying a Formula

Select the cell that contains the formula you want to copy, and click the Copy button on the Standard toolbar.

Select the cell (or multiple cells) into which you want to paste the formula, and click the Paste button.

The formula automatically performs the calculation on similarly located data, placing the results into the selected cell(s).