How to Move a Worksheet Between Workbooks in Excel 2010

A lot of Excel users have at least one spreadsheet that contains some important information that rarely changes. Whether it is a product listing or an invoice, it’s something that you access frequently. But if you need to add that sheet to another workbook, without losing the formatting, then you may be wondering about the easiest way to do so. Fortunately Excel has the ability to quickly copy and paste entire worksheets between workbooks by using the steps outlined below.


Copy and Paste an Entire Worksheet Into Another Workbook in Excel 2010

I am copying a worksheet that has a decent amount of formatting, including images, hidden rows, resized rows and columns, a custom header, and several other options. Using the method outlined below, all of these items will be copied as they currently exist in the original sheet. I am also going to be leaving a copy of the original worksheet in the original workbook, but you will also have the option to move the worksheet to the second workbook, thereby removing it from the first workbook.


Step 1: Open both the original workbook and the workbook to which you want to move the original worksheet. Make sure that you are working in the workbook that contains the original worksheet before you move on to the next steps.


Step 2: Right-click the worksheet tab at the bottom of the window, then select the Move or Copy option.

right-click the sheet tab, select the move or copy option



Step 3: Click the drop-down menu under To book: and select the name of the workbook to which you wish to copy the original worksheet.

how to copy a worksheet in excel 2010



Step 4: Select the location in the second workbook where you want to move the original worksheet, check the box to the left of Create a copy (if you want to leave the original worksheet in the first workbook), then click the OK button.

choose to create a copy, and select the location for the sheet in the second workbook



You will note that I did not rename my worksheets from Sheet1, but Excel handles duplicate sheet names by adding a number in parentheses to the end of the sheet name, as in the image below.

copied worksheet



Do you need a simple gift idea that anyone will love? Amazon gift cards can be personalized in a number of different ways, and they can be created in any amount. Click here to learn more.

You can adjust the print settings in Excel 2010 so that it prints your entire workbook, instead of just the current worksheet.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides