When you copy and paste a formula to a new cell, the cell reference in the new cell may change too, based on the kind of cell reference that you use. When you move a formula, regardless of what kind of cell reference that you use, absolute cell reference or relative cell reference, the cell references within the formula do not change. To learn more, see Switch between relative and absolute references.
Do any of the following:
Copy a formula

Select the cell that contains the formula that you want to copy.

On the Standard toolbar, click Copy .

Select the cell that you want to copy the formula to.

Do one of the following:
To paste 
Do this 
The formula and any formatting 
On the Standard toolbar, click Paste . 
The formula only 
On the Home tab, under Edit, click the arrow next to Paste, click Paste Special, and then under Paste, select Formulas.


If you expected different results

Select the cell that contains the cell reference that you want to change.

In the formula bar, click the cell reference that you want to change.

Press + T to move through the combinations.
Tips:

You can also copy formulas into adjacent cells by using the fill handle . Select the cell that contains the copied formula, and then drag the fill handle over the range that you want to fill. Excel adjusts the cell references automatically to include the correct values for each row.

To copy a formula from the cell above the active cell into the cell or the formula bar, press CONTROL + APOSTROPHE (').

To copy the value from the cell above the active cell into the cell or the formula bar, press CONTROL + SHIFT + QUOTATION MARK (").

Move a formula

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

On the Standard toolbar, click Cut .
Tip: You can also move formulas by dragging the border of the selected cell to the upperleft cell of the paste area. Any existing data is replaced.

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

On the Standard toolbar, click Paste .
This moves the formula and any formatting to the new location.
Tip: To paste the selection, press + V .