How to Save Just One Sheet in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on May 29, 2023

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

save just one sheet 1

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.

save just one sheet 1

To save just one sheet (Sheet1) in a 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. In the Ribbon, click the Save icon (or use the keyboard shortcut CTRL + S).

save just one sheet 5

  1. Browse a folder, name the new file (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 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.

google sheets save just one sheet 2

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

google sheets save just one sheet 3

AI Formula Generator

Try for Free

See all How-To Articles