There may be times when you need to duplicate or relocate a worksheet into one more workbook in Excel or make a duplicate of a worksheet in the same workbook. Possibly you want to make adjustments yet maintain the original worksheet.
First, we’ll reveal you exactly how to copy a worksheet from one workbook to one more whether it be an existing workbook or a brand-new one. Right-click on the tab for the worksheet you want to duplicate as well as pick “Move or Copy” from the popup menu.
On the “Move or Copy” dialog box, select the workbook right into which you want to copy the worksheet from the “To book” drop-down listing.
NOTE: To replicate the chosen worksheet into an existing workbook, that workbook has to be open. If the workbook into which you intend to copy the worksheet is not open, it will certainly not be offered in the “To publication” drop-down listing.
We’re mosting likely to replicate the chosen worksheet right into a new workbook, so pick “(brand-new publication)” from the “To publication” drop-down list. Select the “Create a duplicate” check box. Due to the fact that we’re developing a new workbook, there are no worksheets in the “Before sheet” checklist prior to which we can place the duplicated worksheet. It will certainly be the only worksheet in the brand-new workbook.
KEEP IN MIND: If you intend to move the worksheet right into the other workbook, do not pick the “Create a copy” check box.
Click “OKAY”. A new workbook is produced and the worksheet is duplicated right into it. If you selected to relocate the worksheet, it will no longer be in the original workbook.
You can also make a copy of a worksheet in the very same workbook. You might wish to do this if you wish to make adjustments to a worksheet, however you do not want to transform the initial. Open the “Move or Copy” dialog box the same way we defined previously in this write-up. By default, the current workbook is selected in the “To publication” drop-down checklist, so do not alter that. In the “Before sheet” listing, pick the sheet prior to which you wish to insert the copied worksheet. We’ll pick to put the copy of the worksheet at the end of the existing worksheets. Select the “Create a copy” check box and also click “OKAY”.
The worksheet is inserted to the right of the existing worksheet tabs.
This attribute is an useful means to reorganize your worksheets as well as workbooks. You might require do something such as offering only a certain worksheet from a workbook to a person without sending them the entire workbook.