How to save one sheet in Excel
By
SpreadCheaters
Page last updated:
03/01/2023 |
Next review date:
03/01/2025
You can watch a video tutorial here.
An Excel file is called a workbook and it contains multiple worksheets. You may have a workbook with multiple worksheets out of which just one needs to be distributed within your organization.
Step 1 – Select the sheet
– Select the sheet to be copied
Step 2 – Open the Move or Copy box
– Right-click to open the context menu
– Select Move or Copy
Step 3 – Set the parameters
– Under To book: select (new book)
– Click OK
Step 4 – Save the sheet
– The sheet is moved to a new workbook with a single sheet
Step 5 – Open the Save As window
– Go to File > Save
– Click Browse
Step 6 – Save the file
– Choose the folder for the file
– Specify the name of the file
– Click Save
Step 7 – Check the result
– The sheet is saved in a new workbook
