How to Copy Excel 2010 sheet to another workbook

There are many reasons from taking a sheet from one workbook and copying it to another in Excel. This tutorial will show you how to copy excel sheet to another workbook.


Step # 1 – Opening Move or Copy

First of all, you need to have your current worksheet loaded, which you can see here, as well as the new workbook where we are going to move the sheet to. In this example, this is called “NewBook”. At the bottom of the sheet right click on its tab, here “Cost Data”. In the menu that appears click “Move or Copy…”.

Selecting the worksheet to copy

Step # 2 – Copying the Sheet

This will open the “Move or Copy” window. From the drop down box at the top you need to select the name of the workbook to where you are moving the sheet, here “NewBook”. The default is for the sheet to be moved, but we want to copy it, so check the “Create a copy” box. Click “OK”.

Choosing the destination for the worksheet

Step # 3 – Confirming the Copy

This is how to copy excel sheet to another workbook and you will automatically be taken to the new workbook. Here we can see that all of the data has been successfully copied, process complete.

The sheet has successfully been copied to the new workbook