Question: how to copy an excel sheet without formulas?
Answer: Right-click on the worksheet tab of the worksheet you want to copy. ...  Choose Move or Copy Sheet from the Context menu. ...  Check the Create a Copy check box. Using the To Book pull-down list, choose New Book. Click OK. ...  Make sure the newly created workbook is the one displayed.