This tutorial demonstrates how to save just one sheet in Excel and Google Sheets.
Save a Single Sheet
When you have a workbook with multiple sheets, you may need to save only one of those sheets in a separate Excel file. Say you have a file (File 1.xlsx) with three worksheets.
To save just one sheet (Sheet1) in a separate workbook, follow these steps:
- First, copy the sheet to a new workbook. Right-click the sheet tab (Sheet1, in this example), and choose Move or Copy…
- In the Move or Copy window, choose (new book) from the To book drop-down, check Create a copy, and click OK.
A new workbook opens with the default name Book1, containing only the sheet that you copied – Sheet1.
- Now, save the workbook. In the Ribbon, click the Save icon (or use the keyboard shortcut CTRL + S).
- Browse a folder, name the new file (e.g., File2.xlsx), and click Save.
Finally, a single sheet from the first file is saved in the second file.
Save One Sheet in Google Sheets
As in Excel, you can also save just one sheet in Google Sheets.
- In your initial Google Sheets file with multiple sheets (File1), click the arrow on the sheet tab that you want to save (Sheet1), then choose Copy to > New spreadsheet.
- You’ll get a message that the sheet was copied; click Open spreadsheet.
- Name the new Google Sheets file (File2). The new file has only one sheet that you copied.