When you copy formulas to another location, you’ll be able to pick formulaspecific paste options in the destination cells. Here’s how you copy and paste a formula:

Select the cell with the formula you want to copy.

Click Home > Copy, or press Ctrl+C.

Click the cell where you want to paste the formula.
If that cell is on another worksheet, go to that worksheet and click the cell you want.

To paste the formula with its formatting, click Home > Paste or press Ctrl+V.
For other formula paste options, click the arrow below Paste and pick:

Formulas to paste just the formula,

Values to paste the formula result only.

Tip: You can also use the fill handle to copy a formula into adjacent cells on the worksheet.
Verify and fix cell references in the new location
After copying a formula to a new location, it's important to check that its cell references are correct. The cell references may have changed based on the absolute or relative reference type you used.
For example, if you copy a formula two cells down and to the right of cell A1, cells references you used will be updated like this:
This reference: 
Changes to: 
$A$1 (absolute column and absolute row) 
$A$1 
A$1 (relative column and absolute row) 
C$1 
$A1 (absolute column and relative row) 
$A3 
A1 (relative column and relative row) 
C3 
If cell references in the formula don’t give you the result you want, try switching to different reference types.

Select the cell with the formula.

In the formula bar , select the reference you want to change.

Press F4 to switch between the absolute and relative reference combinations, and pick the one you want.
For more information about absolute and relative cell references, see Overview of formulas.
Move a formula to another location
Unlike copying a formula, when you move a formula to another location in the same or another worksheet, the cell references in the formula don’t change, regardless of what type of cell reference you used.

Select the cell that has the formula you want to move.

Click Home > Cut , or press Ctrl+X.

Click the cell where you want to paste the formula.
If that cell is on another worksheet, go to that worksheet and click the cell you want.

To paste the formula with its formatting, click Home > Paste or press Ctrl+V.
For other formula paste options, click the arrow below Paste and pick:

Formulas to paste just the formula,

Values to paste the formula result only.
