82. Excel Tips - Copy Sheet To New Workbook
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
- Right click on the sheet tab, and select Move Or Copy
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.
Training Video on how to Copy Sheet To New Workbook in Excel: