Table of Contents
You can use the Move or Copy feature in Excel to quickly save one specific sheet in an Excel workbook that may have multiple sheets.
The following example shows how to do so in practice.
Example: How to Save One Specific Sheet in Excel
Suppose we have an Excel workbook with four different sheets:
Suppose we would only like to save the sheet named West.
The easiest way to do so is by right clicking the sheet name West and then clicking Move or Copy:
In the new window that appears, choose (new book) from the To book: dropdown menu and then check the box next to Create a copy:
Once you click OK, a new workbook will be generated that only contains the sheet name West:
You can then save this workbook and only the sheet name West will be saved in it.
Note that the original West sheet will still be saved in the original workbook since we checked the box next to Create a copy.
If you don’t want the original West sheet to remain in the original workbook, simply don’t check the box next to Create a copy.