See all How-To Articles

How to Copy a Spreadsheet in Excel & Google Sheets

This tutorial demonstrates how to copy a spreadsheet in Excel and Google Sheets.

 

Copy Sheets Example

 

Copy by Dragging

  1. Select the sheet tab of the sheet you wish to copy and then, holding down the CTRL key on the keyboard, drag the tab to the left or right.

 

CopySheets Drag

 

  1. Release the mouse to create a copy of the sheet.

 

CopySheets Drag NewSheet

 

Note: If you don’t hold down the CTRL key, the original sheet is moved to a new position in the workbook and not copied.

Copy With the Quick Menu

In the Active Workbook

  1. Right-click on the sheet tab of the sheet you wish to copy to show the Quick Menu, and then select Move or Copy.

 

CopySheets QuickMenu

 

  1. Select (move to the end), then ensure that the check box next to Create a copy is checked.

 

CopySheets CopySheet

 

Note: If you don’t select Create a copy, the sheet is moved to the end of the workbook.

  1. Click OK to create a copy of the worksheet in the active file.

New or Different Workbook

You can also use the Quick Menu to copy the sheet to a new book or a book that is already open in Excel.

  1. Right-click the sheet tab and select Move or Copy Sheet.
  2. In the To book drop-down list, select (new book) to create a new workbook. (The drop-down list shows all open workbooks and the ability to create a new book).
  3. Make sure Create a copy is checked, then click OK.

 

CopySheets NewBook

 

A copy of the sheet is placed on your screen into a new workbook.

Copy Using the Ribbon

You can also obtain the Move or Copy dialog box by using the Ribbon.

  1. In the Ribbon select Home > Cells > Format > Move or Copy Sheet…

 

Copy Sheets Ribbon

 

  1. Select the options you want and click OK.

 

CopySheets CopyMove

 

Copy a Google Spreadsheet

Duplicate Spreadsheet in Existing File

Click on the little drop-down arrow to the right of the sheet tab required (or right-click) to obtain the Quick Menu, and then select Duplicate.

 

CopySheets GS Duplicate

 

A copy of the sheet is immediately placed within your Google file.

 

CopySheets GS Duplicated

 

Copy to an Existing or New Google file

Click on the little drop-down arrow to the right of the sheet tab required (or right-click) to obtain the Quick Menu, and then select Copy To.

To copy to a new spreadsheet, select New spreadsheet.

OR

To copy to an existing spreadsheet, select Existing spreasheet.

CopySheets GS Existing File

 

Select the file you wish to copy the sheet to, and then click Select.

Once the sheet is copied to a New or Existing File, the following dialog box will appear:

CopySheets GS Copy

To open the file where the sheet has been copied to, click OK.