Search

How to Move or Copy entire worksheet to another Excel workbook

 

Sometimes you may need to move or copy the whole worksheet to another Excel workbook. You can move or copy a worksheet to another Excel workbook by following below steps.

Note that "Move" means copying the whole worksheet to another workbook and deletion of copied worksheet from original workbook. "Copy" means the duplication of whole worksheet in another workbook.

Step 1 - Make sure both workbooks are open in Excel (the workbook from where the worksheet is copied and the workbook to where the worksheet is copied or moved).

Step 2 - Right-click on the worksheet Tab which you want to move or copy to another workbook and select "Move or Copy" from the menu, as shown in below image. Note that the name of current active workbook name is "source_workbook.xslx", which is displayed in Titlebar.

Worksheet Move or copy menu

Step 2 - "Move or Copy" dialog box will be displayed as shown in below image. By default, the active workbook (the workbook you are working) is selected in "Move selected sheets To book" Drop-down menu.

Worksheet Move or copy to another workbook  dialog box

Step 3 - Click on "Move selected sheets To book" Drop-down menu. Currently open workbooks are listed in "Move selected sheets To book" Drop-down menu. You have an option to move the worksheet to a new workbook also.

Move selected sheets To book Drop-down menu

Step 4 - Perform below activities on "Move or Copy" dialog box to move or copy the worksheet to another workbook, as shown in below image.

• Currently open Excel workbooks are listed in "Move selected sheets To book" Drop-down menu. Select the workbook to which you want to copy the worksheet. In this example, the workbook is copied to "destination_workbook.xlsx".

• The worksheets in the selected workbook is listed in in "Before sheet" list box. Copied or moved worksheet's new position will be before the selected worksheet. Select the position where you want to move of copy the worksheet.

• Select whether you want to move or copy the worksheet in "Create a copy" checkbox. If the checkbox is checked, the worksheet will be copied. Else the worksheet will be moved. In this example, the checkbox is checked to copy the worksheet.

• Click "OK" button to finish worksheet copy or move, as shown in below image.

Worksheet Move or Copy to another Workbook

 

Step 5 - You can see that the worksheet is copied to another workbook as shown in below image. You may rename it according to your requirement.

Worksheet is copied to another workbook

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook