Copy Grouped Excel Worksheets When a Sheet Contains a Table
Question details
Copy multiple Excel worksheets to another workbook when one or more sheets contain an Excel table.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to copy grouped worksheets into a new or existing workbook.
- Observed behavior
- Excel cannot copy or move the grouped worksheets when a selected sheet contains an Excel table.
Open the destination workbook if you want to copy sheets into an existing file. Check which source worksheets contain Excel tables by clicking in their data and looking for the Table Design tab.
Copy Worksheets with Tables Individually
Use this method to retain Excel table features while copying the worksheets.
In the source workbook, select the tabs of the worksheets that do not contain tables, using Ctrl-click to select nonadjacent sheets or Shift-click to select a range of tabs.
Right-click a selected sheet tab and choose Move or Copy. In To book, select the open destination workbook or (new book), choose a position, select Create a copy, and click OK.
Select a worksheet containing a table on its own. Right-click its tab, choose Move or Copy, select the destination workbook and position, then select Create a copy and click OK. Repeat for each remaining table sheet.

Convert Tables to Ranges Before Copying Grouped Worksheets
Use this method if you need to copy all selected sheets as a group and do not need to preserve their table features.
Work with Excel Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet for an easier transition between office suites; it does not change Excel's grouped-sheet copying limitation.

Frequently Asked Questions
Why can't I copy my selected Excel worksheets together?
Excel cannot copy or move a group of worksheets when one of the selected sheets contains an Excel table. Copy sheets without tables as a group, then copy each table sheet individually.
How can I keep the original worksheets in their workbook?
Right-click the selected sheet tab, choose Move or Copy, and select Create a copy before clicking OK. Otherwise, Excel moves the selected sheets.
Will converting a table to a range delete its data?
No. Table Design > Convert to Range keeps the data and generally retains the formatting, but removes Excel table functionality.
Can I copy the worksheets into a new workbook?
Yes. In the Move or Copy dialog, select (new book) under To book. Copy sheets containing tables individually unless you first convert their tables to ranges.




