See all How-To Articles

Copy Multiple Sheets to New Workbook – Excel & Google Sheets

This tutorial demonstrates how to copy multiple sheets to a new workbook in Excel and Google Sheets.

Copy Multiple Adjacent Sheets

  1. In the workbook that contains the sheets you wish to copy, click on the tab of the first sheet required.

 

CopySheet SelectFirstTab

 

  1. Holding down the SHIFT key, click on the tab of last sheet required. This will put your sheets into group mode; the group includes all sheets between the first one that was selected and the last.

 

CopySheet SelectLastTab

 

  1. Right-click on one of the selected sheet tabs, and then select Move or Copy.

 

CopySheet Adjacent RightClick

 

  1. In the dialog box, select (new book) from the To book drop-down list, make sure that the Create a copy check box is checked, and then click OK.

 

CopySheet Adjacent MoveOrCopy

 

A new Workbook is created with the selected sheets.

 

CopySheet Adjacent NewBook

 

Copy Multiple Non-Adjacent Sheets

  1. In the workbook that contains the sheets you wish to copy, click on the tab of the first sheet required.

 

CopySheet Quarter1

 

  1. Holding down the CTRL key, click on each of the tabs of the sheets you wish to copy. This will put your sheets into group mode, and the group includes only the selected sheets.

 

CopySheet Non Adjacent Select

 

  1. Right-click on one of the selected sheet tabs, and then select Move or Copy.

 

CopySheet NonAdjacent RightClick

 

  1. In the dialog box, select (new book) from the To book drop-down list, make sure that the Create a copy check box is checked, and then click OK.

 

CopySheet Adjacent MoveOrCopy

 

A new workbook is created with the selected sheets.

 

CopySheet Non Adjacent NewBook

 

Note: Copying sheets between workbooks and to new workbooks can also be done with VBA.

Copy Multiple Sheets in Google Sheets

Copying sheets in Google Sheets works in the same way.

  1. Select the first sheet you wish to copy, and then holding down the SHIFT key, select the last sheet.

 

CopySheet GoogleSheets SelectTabs

 

  1. As in Excel, right-click on the sheet tab, and select Copy to > New Spreadsheet.

 

CopySheet GoogleSheets CopyTo

 

  1. Click Open spreadsheet to open the new spreadsheet. A new window opens in your browser with the selected sheets copied into it.

 

CopySheet_GoogleSheets SucessMessage

 

  1. Click OK in your spreadsheet to dismiss the message.

To copy non-adjacent sheets in Google Sheets, hold down the CTRL key when selecting the sheet tabs.

 

CopySheet_GoogleSheets Non Adjacent Tabs

 

Then follow the procedure as above.