Save Only One Worksheet

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.

save one worksheet

Leave a Comment