Copy/Move tab to New Workbook

Copy/Move Excel Sheet (tab) into another workbook

There are a couple ways you can go about copying or moving a tab into another workbook.

1. To Move: Press CTRL and drag the worksheet tab to the new workbook. Sheet is now moved into the new workbook

2. Or

a. Right click on the worksheet tab and select Move or Copy.

b. Select Create a copy checkbox if you want to copy into the new worksheet.

c. Under Move Selected Sheets — To Book: Select the excel file you want to copy the sheet to. **Note the file must be open to copy a file into**

d. Under Before sheet, select where you want to place the copy.

e. Select OK.

Permanently Move Sheet to New Worksheet

1. Right click on the worksheet tab and select Move or Copy.

2. **Do not select Create a copy checkbox (see previous image).

3. Under Move Selected Sheets — To Book: Select the excel file you want to move the sheet to. **Note the file must be open to copy a file into**

4. Under Before Sheet, select where you want to move the sheet.

5. Select Ok.