Question: how do you copy and paste in excel while maintaining the original references?
Answer: To copy the formula entered using absolute references and preserve the cell references, select the cell containing the formula and copy it (Ctrl + C) and click the destination cell into which you want to paste the formula. Make sure the Home tab is the active tab on the ribbon.