Question: how to copy excel sheet to another 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.