Fix Excel 2016 Move or Copy Worksheet Not Working
Question details
The user needs to move or copy worksheets in Excel 2016 when the Move or Copy feature does not work.

- 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.
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.
Check the Move or Copy dialog settings
Use the worksheet tab menu to choose the destination and specify whether to create a copy.
Right-click the worksheet tab you want to move or copy, then select Move or Copy.
In the To book list, select the current workbook or an open destination workbook. Under Before sheet, choose where to place the worksheet.
Select Create a copy to keep the original sheet. Leave it unchecked if you want to move the original, then click OK.

Copy a worksheet within the workbook using Ctrl-drag
Use this workaround if the dialog still fails and you only need a duplicate in the same workbook.
Repair Office 2016 on Windows
Try an Office repair if the Move or Copy dialog still does not work.
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.

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.




