Sometimes you might discover it required to duplicate existing worksheets in Excel right into one more workbook. Today we show you how easy it is to duplicate a worksheet to one more workbook in Excel 2007 & 2010 Beta.
Copy Worksheet in Excel 2007 & 2010
Initially open up the workbook with the sheet you want to copy, right-click on the sheet tab as well as choose Move or Copy.
Make sure you have the workbook(s) that you intend to copy the sheet into open for them to turn up in the “To publication” dropdown listing, after that select the one to duplicate to. If the workbook that you want to duplicate to isn’t open, it won’t turn up in the dropdown list.
In the Move or Copy dialog box inspect package next to Create a duplicate. You can additionally pick to have it prior to the existing sheet or at the end … after that click Ok.
That is all there is to it! Now you can go into the workbook you duplicated it to as well as send it off or work on it.
You can also replicate and relocate the worksheet right into the same workbook or right into a new workbook as well.
This is a lot easier than sending numerous workbooks to your colleagues as well as can make structure workbooks a lot easier.