To save several sheets from your workbook together in a new file, you can do the following in Excel:
- First select the sheets (you can select multiple by holding the Control key), and the right-click on one of them.
Then choose "Move or Copy...
- Select (new book) and check "Create a copy":
- After you've pressed the OK button you'll notice that a new workbook is created with the selected sheets only:
- Now you have a new workbook with only the selected sheets which you can save as a new file.
You may also like:
Filed under: How to on October 21st, 2011 by Bastien | Comments Off on How to: Save several worksheets together in a single new workbook