Question: how to duplicate an excel sheet with formulas?
Answer: Select the cell containing the formula that you want to copy. In the Clipboard group of the Home tab, click Copy. Do one of the following: ...  Verify that the cell references in the formula produce the result that you want. ...  Select the cell that contains the formula.