Question: how to copy formula from one sheet to another in excel automatically?
Answer: Select the cell that has the formula you want to move.
Press. + X.
Click the cell where you want to paste the formula. If that cell is on another worksheet, go to that worksheet and click the cell you want.
To paste the formula with its formatting, on the Home tab, click Paste or press.