See all How-To Articles

How to Save Just One Sheet in Excel & Google Sheets

This tutorial demonstrates how to save just one sheet in Excel and Google Sheets.

 

save just one sheet 1

 

Save a Single Sheet

In case when you have a workbook with multiple sheets, you may need to save only one sheet in a separate Excel file. Say you have a file (File 1.xlsx) with three worksheets.

 

save just one sheet 1

 

To save just one sheet (Sheet1) in the separate workbook, follow these steps:

  1. First, copy the sheet to a new workbook. Right-click the sheet tab (Sheet1, in this example), and choose Move or Copy…

 

save just one sheet 2

 

  1. In the Move or Copy window, choose (new book) from the To book drop-down, check Create a copy, and click OK.

 

save just one sheet 3

 

A new workbook opens with the default name Book1, containing only the sheet that you copied – Sheet1.

 

save just one sheet 4

 

  1. Now, save the workbook. To do that, in the Ribbon, press the Save icon (or use the keyboard shortcut CTRL + S).

 

save just one sheet 5

 

  1. Browse a folder, give your file a name (e.g., File2.xlsx), and click Save.

 

save just one sheet 6

 

Finally, a single sheet from the first file is saved in the second file.

 

save just one sheet 7

 

See also…

Save One Sheet in Google Sheets

As in Excel, you can also save just one sheet in Google Sheets.

  1. In your initial Google Sheets file with multiple sheets (File1), click on the arrow on the sheet tab that you want to save (Sheet1), then choose Copy to > New spreadsheet.

 

google sheets save just one sheet 1

 

  1. You’ll get a message that the sheet was copied; click Open spreadsheet to open it.

 

google sheets save just one sheet 2

 

Name the new Google Sheets file (File2). The new file has only one sheet that you copied.

 

google sheets save just one sheet 3