Question: how to copy excel formula without file reference?
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.