See all How-To Articles

How to Copy an Entire Workbook in Excel & Google Sheets

In this tutorial, you will learn how to copy an entire workbook in Excel and Google Sheets.

 

copy entire workbook 7

 

If you want to make a copy of a workbook, without affecting the original there are few ways to do that.

Open Workbook as Copy

One way to copy a workbook is to open it as a copy.

  1. In the Ribbon, click on the File tab. From the drop-down menu, choose Open > Browse.

 

copy entire workbook 1

 

  1. In the Open window, select the workbook you want to copy, click on the down-arrow next to the Open button, and choose Open as Copy.

 

copy entire workbook 14

 

As a result, Excel opens a copy of the workbook.

 

copy entire workbook 15

 

Copy Workbook in Folder

You can also copy a workbook through the File Explorer, in the folder where it’s located.

  1. Go to the folder where you saved the workbook you want to copy. In the folder, right-click the workbook, and from the drop-down menu, choose Copy (or use the keyboard shortcut CTRL + C).

 

copy entire workbook 16

 

  1. After that, right-click anywhere in the folder, and from the drop-down menu choose Paste (or use the keyboard shortcut CTRL + V).

 

copy entire workbook 6

 

As a result of this, a copy of the workbook you selected will appear in the folder.

 

copy entire workbook 7

 

You can also use VBA code to copy an entire workbook.

Use Save As

The third option is to use “Save As.”

  1. In the Ribbon, click on the File tab. From the drop-down menu choose Save As > Browse.

 

copy entire workbook 8

 

  1. After that Save As window will open, in the File name just rename the workbook, and click on Save.

 

copy entire workbook 9

 

After you click on save, Excel will open a copy of the workbook.

 

copy entire workbook 10

 

Copy a Google Sheets Worksheet

Copying an entire file works a bit differently in Google Sheets.

  1. In the Menu, click on File > Make a copy.

 

copy entire workbook 12

 

  1. After that, the Copy document window will open, in the Name section rename the workbook you want to copy, and click on OK.

 

copy entire workbook 11

 

As a result, a copy of the workbook will open in a new tab in your browser.

 

copy entire workbook 13