Document Editing Problems

Fix Excel 2016 Move or Copy Worksheet Not Working

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 868 views

Question details

The user needs to move or copy worksheets in Excel 2016 when the Move or Copy feature does not work.

Fix Move or Copy Worksheet Not Working in Excel 2016
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Moving or copying a worksheet within the same workbook or to another workbook.
Observed behavior
Excel may fail to move or copy the worksheet, even after Office is reinstalled.
Before you start

Open the source workbook and, if you want to move or copy a sheet to another file, open the destination workbook too. Check whether you want to move the original sheet or create a duplicate.

Solution 1Recommended

Check the Move or Copy dialog settings

Use the worksheet tab menu to choose the destination and specify whether to create a copy.

1
Open the dialog

Right-click the worksheet tab you want to move or copy, then select Move or Copy.

2
Choose the destination

In the To book list, select the current workbook or an open destination workbook. Under Before sheet, choose where to place the worksheet.

3
Set the copy option

Select Create a copy to keep the original sheet. Leave it unchecked if you want to move the original, then click OK.

Check the Move or Copy dialog settings
Free Microsoft Office alternative

Manage Excel worksheets with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet files. Its format compatibility makes it easier to move existing workbooks into WPS, although it does not repair Excel itself.

Work with worksheet tabs in WPS SpreadsheetCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why did Excel move my sheet instead of copying it?

In the Move or Copy dialog, select Create a copy before clicking OK. If the box is unchecked, Excel moves the original sheet.

How do I copy a sheet to another workbook?

Open both workbooks, right-click the source sheet tab, and select Move or Copy. Choose the destination in the To book list, select Create a copy, and click OK.

Can I duplicate a sheet without opening the Move or Copy dialog?

Yes. Within the same workbook, hold Ctrl and drag the sheet tab to a new position. Release the mouse button before releasing Ctrl.

What can I try if reinstalling Office did not fix the command?

On Windows, go to Control Panel > Programs > Programs and Features, select Microsoft Office 2016, and click Change to access the available repair options.