How To Copy Excel Sheet With Formulas. Find and replace with another. Copy a formula select the cell containing the formula that you want to copy.
Find and replace with another. To quickly paste the formula with its formatting press v. Then from move or copy box check the box of create a copy with tick and press ok to proceed for creating a copy of that sheet.
If that cell is on another worksheet go to that worksheet and click.
In the clipboard group of the home tab click copy. Use this method to quickly copy a formula without changing the cell references. Find and replace with another. Open the find window.
