Top Nav

How to Copy a Worksheet Into Excel Workbooks

When working through Excel in Microsoft Office during the day you might find it necessary to copy an existing worksheet in to another workbook. Here’s the process for doing it – it’s simple!

While you can simply drag and drop worksheets into different workbooks without any problems, which is fine for basic Excel work. But if you’re working between enormous workbooks at the office, or at home for that matter, this can help keep things a bit more neat and organized.

Copy or Move Worksheets to a Different Excel Workbook

Open the workbook with the sheet you want to copy and right-click on the Sheet’s tab at the bottom. Then select Move or Copy. For example, here I am going to copy the Supplies sheet in the workbook to another one.

Move or Copy worksheets

Next make sure you have the workbook you want to copy the sheet into is opened up. Select the  the workbook you want to copy or move the sheet to. Note that if the workbook you want to copy the sheet to isn’t open, it won’t show on the list.

In this instance I am going to move the Supplies worksheet to a different spreadsheet called Event Budget. Here you can also select where you want to move the worksheets in the book.

copy or move

In this example I moved it to the end to make things easier.

Sheet Moved

it’s also possible to copy or move a worksheet in the same workbook, or create a new book with them. I find this comes in handy when you’re books become out of control with way to much info, and all you need to do is get a few of the basic sheets together. In this example I copied the Profit – Loss Summary sheet to the end. it will display a different number to keep track of which copy of the sheet you have made and distinguish it from the original.

same workbook

This is a simple demonstration on how to move your worksheets around. But when you’re dealing with huge workbooks and spreadsheets at the office. There will be times when the boss will want specific sheets in specific books. And let’s face it, the boss has no clue how to do these things!

More Reading:


No comments yet.

Leave a Reply


Free Learning


Don't miss a single tip, how to or tech news update. Subscribe to my free newsletter and receive updates, right to your inbox.

You have Successfully Subscribed!