Transfer a worksheet to another Excel workbook: without VBA

Transfer a worksheet to another Excel workbook: without VBA

In case you work in one Excel workbook that you'd like to move to another one, there is a simple solution that doesn't require knowing macros or VBA codes – it can be done in a few simple clicks. Read on to find out how to transfer a worksheet to another Excel file.

How to transfer worksheet to another Excel file?

To transfer one worksheet to another Excel workbook, follow these instructions:

1. Open your workbook and right-click on the tab of the sheet you want to copy.

2. Select Move or Copy option from the drop-down menu and the prompt window will open.

excel move or copy
© Excel

3. Now you can select whether you want to copy this worksheet to a new workbook or to an existing one. Select the one of your choice from the drop-down menu.

Note: If you want to move your worksheet into an existing workbook, it has to be open. Otherwise, it won’t appear on the list.

4. Select where you’d like to insert a worksheet in the Before Sheet section.

5. Check mark the Create a Copy tab and then click OK. You will see your worksheet successfully added to another workbook.

Note: Be careful : if you don't check the Create a Copy box, the sheet will move without creating a copy and you will not be able to find the original in the folder.

Do you need more help with excel? Check out our forum!
Subject Replies
How to calculate positions(1st,2nd,3rd...) in Excel 4
Unable to change date format in Excel 39
How to convert number into text in Excel 9
Convert number to spelling 28
Date formatting in dd/mm/yyyy 11
Removing " false" value in "IF" 10
Automatically transfer data from one sheet to another 22
Comparing two columns of names in Excel 8
Excel - To generate unique ID 4
converting number into words (Excel) 6

Excel