How to save just one worksheet in a workbook in Excel?

Have you ever needed to save just one specific worksheet from an Excel workbook, instead of the entire file? Whether you’re sharing a particular dataset or creating a focused report, isolating a single worksheet can be incredibly useful. Luckily, Excel offers several easy methods to achieve this. Let’s explore the best approaches to save only the worksheet you need, step by step.

Save just one worksheet as new Excel file with Move or Copy
Save just one worksheet as new Excel file with Kutools for Excel
Save just one worksheet as new Excel file with VBA code

Save just one worksheet as new Excel file with Move or Copy

The Move or Copy utility of Excel feature helps you to easily save a certain worksheet as a new Excel file. You can do as follows.

1. Right click on the sheet tab (the worksheet you need to save as new file) in the sheet tab bar, then click "Move or Copy".

2. In the "Move or Copy" dialog box, select (new book) from the "To book" drop-down list, check the "Create a copy" box, and then click the OK button. See screenshot:

3. Then the specified worksheet is moved in a new created workbook, please save this workbook manually.

Save just one worksheet as new Excel file with Kutools for Excel

Facing a large Excel workbook and just want to extract a single worksheet to save separately? Stop copying and pasting manually! Kutools for Excel offers you a few clicks solution!

1. Click "Kutools Plus" > "Split Workbook", see screenshot:

2. In the "Split Workbook" dialog box, check the worksheet you want to save, and specify the file format(Excel, PDF, TXT...), then, click "Split" button. See screenshot:

3. And then, choose a folder to save the new Excel file.

Save just one worksheet as new Excel file with VBA code

If you frequently need to save individual worksheets, a simple VBA macro can save time:

1. Select and open the worksheet that you want to save as a new file.

2. Press "Alt + F11" simultaneously to open the "Microsoft Visual Basic for Application" window.

3. In the Microsoft Visual Basic for Application window, click "Insert" > "Module". Then copy and paste below VBA code into the Module window.

VBA code: Save just one worksheet as new Excel file

Sub SaveWorksheetAsNewWorkbook()
'Updateby Extendoffice
    Dim ws As Worksheet
    Dim newBook As Workbook
    Set ws = ActiveSheet
    Set newBook = Workbooks.Add
    ws.Copy Before:=newBook.Sheets(1)
    newBook.SaveAs Application.GetSaveAsFilename(InitialFileName:=ws.Name & ".xlsx", FileFilter:="Excel Files (*.xlsx), *.xlsx")
    newBook.Close
End Sub

4. Press the F5 key to run the code. A window will appear to remind you to specify the file name and location for the new workbook. The active worksheet will be saved as a standalone Excel file.

The methods introduced in this article allow you to easily save a single sheet from an Excel workbook as a new workbook or file in other formats. These methods are simple to use and can improve efficiency in daily work without tedious manual operations. You can choose the method that suits your needs to accomplish the task, enabling better management and sharing of data. If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials.

Save just one worksheet as Excel file