Save Only One Worksheet

September 14th, 2004 | Categories: General | Tags:

This question was asked by a friend; “How do I save only one worksheet in a workbook with many worksheets?” Technically you can’t, unless you delete all of the other worksheets, however you can copy the tab you want to save to another workbook and save it by it’s lonesome there.

1. Right click on the tab you want to save and select Move or Copy…
2. In the To Book: dropdown menu select (new book)
3. Place a checkmark in the Create a copy box and hit OK
4. This created a new workbook with only your selected sheet in it. You can now go to a newly created workbook and save as you would like. Save or discard your old workbook.

saveone


Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
No comments yet.