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

Steps:

1. Right click on the sheet tab, and select Move Or Copy

   • 

2. Populate the details as shown:

   • 

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: