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.