How to Separate / Split Sheets in Excel & Google Sheets

This tutorial demonstrates how to separate sheets in Excel and Google Sheets.

 

original file sheets

 

The individual pages of an Excel document are called worksheets. When you have several worksheets in one file, you can separate the sheets into new or existing workbooks using Move or Copy options.

Move to a New Workbook

Say you have a workbook with four worksheets.

 

split sheets in excel initial data

 

To move Sheet4 into a new workbook, follow these steps:

1. Right-click the sheet you want to move (Sheet4), and choose Move or Copy.

 

move a sheet into new workbook

 

2. In the Move or Copy window, choose (new book) from the drop-down list and click OK.

 

move a sheet into new workbook 2

 

This creates a new workbook, and Sheet4 is moved from the original file to the new one.

 

move a sheet into new workbook 3

 

Now, you can now save the new workbook and modify Sheet4. As you can see above, the names of newly created workbooks are generated automatically (Book1, Book2, etc.).

Move to Existing Workbook

You can also move a sheet into an existing workbook. For example, to move Sheet3 to the workbook Book2, follow these steps:

1. Make sure both the original and target (here, Book2.xlsx) workbooks are open.

2. Go to the original workbook, right-click the sheet you want to move (Sheet3), and choose Move or Copy.

 

move a sheet into existing workbook

 

3. In the Move or Copy window, choose a workbook where you want to move the sheet (Book2.xlsx), select (move to end) in the Before sheet box, and click OK. Since there are existing worksheets in the selected workbook, select where you want to position a new sheet (before certain sheet or at the end).

 

move a sheet into existing workbook 2

 

4. Go back to the Book2.xlsx workbook. Sheet3 is moved from the original file to this one, after Sheet4.

 

move a sheet into existing workbook 3

 

Copy a Worksheet

You can also copy a worksheet into another workbook. A copied worksheet is both kept in the original file and copied to a new or existing workbook. Say you want to copy Sheet2 to the workbook Book2.xlsx.

1. Start by opening a target file (Book2.xlsx), just like the previous case. Right-click the sheet you want to copy (Sheet2), and select Move or Copy.

 

copy a sheet into existing workbook

 

2. In the Move or Copy window, (1) choose where you want to copy the sheet (Book2.xlsx), (2) position the worksheet in the target workbook (move to end), (3) check Create a copy, and (4) click OK.

 

copy a sheet into existing workbook 2

 

The worksheet is copied to another workbook, and also kept in the original file.

 

copy a sheet into existing workbook 3

 

To move or copy sheets within a macro, see VBA Copy Worksheet.

Copy to a New File in Google Sheets

In Google Sheets, you can’t move a sheet between files, but you can copy a sheet to a new or existing file. To copy Sheet2 to a new file:

1. Right-click on the sheet you want to copy (Sheet2), or click the arrow next to the sheet name.

2. In the Menu, choose Copy

3. Then click New spreadsheet.

 

google sheets copy a sheet to a new file

 

As a result, Sheet2 is now copied to a new file (Untitled spreadsheet).

 

google sheets copy a sheet to a new file 2