Office Compatibility Issues

Copy Grouped Excel Worksheets When a Sheet Contains a Table

Steve KSteve K Nov 22, 2026 868 views

Question details

Copy multiple Excel worksheets to another workbook when one or more sheets contain an Excel table.

How to Copy Grouped Excel Worksheets When One Contains a 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.
Before you start

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.

Solution 1Recommended

Copy Worksheets with Tables Individually

Use this method to retain Excel table features while copying the worksheets.

1
Group sheets without tables

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.

2
Copy the grouped sheets

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.

3
Copy each table sheet

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.

Copy Worksheets with Tables Individually
Copying versus moving: Select Create a copy to keep the original worksheets in the source workbook. Leaving it unchecked moves them instead.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesWork with multiple worksheets in a familiar tabbed interfaceUse a free, lightweight office suite for everyday spreadsheet tasksMove existing compatible workbooks into WPS without starting from scratch
microsoft office alternative - wps office

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.