How to save one sheet in Excel

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