Question: how to copy and paste multiple formulas without changing 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.