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
Steps:
- 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.
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:
Attachment | Size |
---|---|
copy-sheet-to-new-workbook.xls | 27 KB |
»
- Nick's blog
- Login or register to post comments
- 13309 reads
Recent comments
5 years 51 weeks ago
6 years 37 weeks ago
6 years 49 weeks ago
6 years 51 weeks ago
7 years 5 days ago
7 years 6 weeks ago
7 years 14 weeks ago
7 years 14 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago