When copying formulas, the references change depending on the column and row you are pasting to. If a value in a referenced cell is copied, to maintain the new cell as a value choose Edit Paste Special and click on value then click OK. The pasted cell is no longer a formula.
Let's copy cell C1 to two cells two different ways: