82. Excel Tips - Copy Sheet To New Workbook

Nick's picture

You often need to create a copy of the sheet you're currently working on

  • One way is to saveAs another file name, then delete the extra sheets... but there is a better way


  1. Right click on the sheet tab, and select Move Or Copy
    • copy-sheet-to-new-workbook

  2. Populate the details as shown:

    • copy-sheet-to-new-workbook

This will create a new workbook with all the details from the worksheet copied over, leaving the original untouched.

You can now save this, and continue to work on it.

Download sheet to practise how to Copy Sheet To New Workbook in Excel

Training Video on how to Copy Sheet To New Workbook in Excel:

copy-sheet-to-new-workbook.xls27 KB