SEARCH

How-To Geek

How To Copy Worksheets in Excel 2007 & 2010

Sometimes you may find it necessary to copy existing worksheets in Excel into another workbook. Today we show you how easy it is to copy a worksheet to another workbook in Excel 2007 & 2010 Beta.

Copy Worksheet in Excel 2007 & 2010

First open the workbook with the sheet you want to copy, right-click on the sheet tab and select Move or Copy.

1copy

Make sure you have the workbook(s) that you want to copy the sheet into open for them to show up in the “To book” dropdown list, then choose the one to copy to. If the workbook that you want to copy to isn’t open, it won’t show up in the dropdown list.

3copy

In the Move or Copy dialog box check the box next to Create a copy. You can also choose to have it before the existing sheet or at the end… then click Ok.

4copy

That is all there is to it! Now you can go into the workbook you copied it to and send it off or work on it.

5cp[u

You can also copy and move the worksheet into the same workbook or into a new workbook as well.

6copy 

This is much easier than sending multiple workbooks to your coworkers and can make building workbooks much easier.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+

  • Published 01/8/10

Comments (5)

  1. Jayso

    For those running older versions, this will also work in Excel 2003. Not sure about versions older than that though.

  2. David

    Actually it will work for older versions (at least to Excel 5, from personal recollection)

  3. James

    Bigger question: how to send individual sheets from Excel 2007. This was possible in Office 2003, but I had to install a 3rd-arty add-in to get this to work on Excel 2007.

  4. Jb007

    thanks a lot. it is very much used for me to copy a worksheet…..

  5. YDeCosta

    Is there another way to do this? My Move or Copy option isn’t available.*y

Enter Your Email Here to Get Access for Free:

Go check your email!