Question: how do you copy and paste formulas in excel without changing cell references?
Answer: Select the cells that have the formulas that you want to copy. Go to Home –> Find & Select –> Replace. In the Find and Replace dialog box: ...  Click OK. ...  Copy these cells. Paste it in the destination cells. Go to Home –> Find & Replace –> Replace.