Question: how to copy a column in excel to another sheet using formula?
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.