There are two ways to move or copy a column. To paste the formula with its formatting, click Home > Paste or press Ctrl+V. On the same sheet or another sheet, click onto the cell into which you'll paste the formula. Here’s how you copy and paste a formula: Select the cell containing the formula you want to copy. › Usp Reference Standard Current Catalogueįrequently Asked Questions How do you paste formulas in excel?.