Question: how do you copy and paste a formula in excel without it changing?
Answer: Select the cell with the formula you want to copy. Select the formula in the formula bar using the mouse, and press Ctrl + C to copy it. ...  Press the Esc key to exit the formula bar. Select the destination cell and press Ctl + V to paste the formula there.