Move or Copy an Excel Worksheet with a Table to Another Workbook
Question details
Move or duplicate a worksheet that contains an Excel table into another workbook without using VBA.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to transfer a complete worksheet, including its table, to an existing or new workbook.
- Observed behavior
- The worksheet should be moved or copied while retaining its table structure, formatting, and data as much as possible.
Open both the source workbook and the destination workbook before starting so the destination appears in the workbook list. Confirm whether you need to preserve the original sheet, because moving removes it from the source workbook.
Use Move or Copy to transfer the entire worksheet
Use this method when you want to move or duplicate the full worksheet, including the table, layout, formulas, and worksheet formatting.
The built-in Move or Copy command transfers the worksheet as a sheet rather than recreating its cells manually. After copying to another workbook, review formulas, named ranges, and external links if the table depends on other sheets in the original file.
Open the workbook containing the table and the workbook that will receive the worksheet in Excel.
Right-click the worksheet tab that contains the table, then select Move or Copy.
In the To book list, select the destination workbook. To create a separate file, select (new book).
In the Before sheet list, select the sheet that the moved or copied worksheet should appear before.
Select Create a copy to keep the original worksheet in the source workbook, then click OK. Leave Create a copy unchecked to move the worksheet.
Copy the table contents into a new worksheet when only the data is needed
Use this method when you need only the table and its contents, rather than every item on the original worksheet.
Move or Copy a Worksheet with a Table in WPS Spreadsheets
WPS Spreadsheets lets you transfer an entire worksheet with its table to another open workbook through the sheet-tab context menu. You can choose whether to move the sheet or create a copy, then verify any formulas that reference other sheets.
- 1. Open the source and destination files: Open both spreadsheet workbooks in WPS Spreadsheets.
- 2. Right-click the worksheet tab: At the bottom of the source workbook, right-click the tab for the worksheet containing the table.
- 3. Select the sheet transfer command: Choose Move or Copy from the worksheet tab menu.
- 4. Set the destination and copy option: Select the target workbook and the position for the worksheet, then select Create a copy if you want to retain the original sheet.
- 5. Confirm and inspect formulas: Click OK, then review table formulas and any references that previously pointed to sheets in the source workbook.
Frequently Asked Questions
Will moving a worksheet also move the Excel table on it?
Yes. When you use the worksheet tab's Move or Copy command, the whole worksheet is transferred, including the table, its data, formatting, and filters.
How do I keep the original worksheet when sending it to another workbook?
Right-click the worksheet tab, select Move or Copy, choose the destination workbook, select the Create a copy check box, and click OK.
Why do formulas show the original workbook name after I copy a sheet?
The formulas may reference cells or named ranges on sheets that remain in the source workbook. Select the affected formula cells and update the references, or copy the dependent sheets as well.
Can I copy a worksheet to a new workbook instead of an existing file?
Yes. In the Move or Copy dialog, choose (new book) in the To book list, select Create a copy if needed, and click OK.
Is copying and pasting the table the same as copying the worksheet?
No. Copying the worksheet preserves more sheet-level content, while copying and pasting transfers only the selected cells and may require you to recheck formatting, table settings, and formulas.
