Fix Excel 2016 for Mac Not Moving or Copying Worksheets
Question details
The user needs to move or copy worksheets in an Excel 2016 for Mac workbook.

- Product
- Microsoft Excel 2016 for Mac
- Device & OS
- Mac
- Scenario
- The user selects Move or Copy on a worksheet in a workbook that is not protected, shared, or read-only.
- Observed behavior
- Move or Copy does nothing, and copying worksheet content can produce a multiple-selection error.
Confirm that the workbook is not protected, shared, or read-only. To check and clean excess formatting, make a working copy and have access to a Windows version of Excel that supports the Inquire add-in.
Check and clean excess formatting in Excel for Windows
Use this method when excess cell formatting may be preventing worksheets from being moved or copied.
Excess cell formatting was identified as the cause in the reported workbooks. The Inquire add-in is available only in supported Windows editions of Excel, not in Excel for Mac.
Open a copy of the affected workbook in a supported version of Excel for Windows.
Select File > Info > Check for Issues > Check Compatibility and review the results for formatting-related issues.
Go to File > Options > Add-ins. Under Manage, select COM Add-ins, click Go, and select Inquire if it is available.
On the Inquire tab, select Clean Excess Cell Formatting. Choose the active sheet or all sheets, then follow the prompts to save the changes.
Open the cleaned workbook in Excel for Mac, right-click the worksheet tab, and select Move or Copy to test it.

Manage Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move your work across. It does not repair Excel for Mac or guarantee that excess formatting will be removed.

Frequently Asked Questions
Why does Move or Copy do nothing in Excel 2016 for Mac?
Excess cell formatting can be one cause, even when the workbook is not protected, shared, or read-only. Check the workbook in Excel for Windows and, if supported, use Inquire > Clean Excess Cell Formatting.
Can I use the Inquire add-in in Excel for Mac?
No. Inquire is available only in supported Windows editions of Excel. Open a working copy of the workbook in Excel for Windows to use it.
Where do I find the compatibility checker in Excel?
In Excel for Windows, open the workbook and select File > Info > Check for Issues > Check Compatibility. Review the results for formatting-related issues.
What if Inquire is not listed in my Excel add-ins?
Go to File > Options > Add-ins, select COM Add-ins under Manage, and click Go. If Inquire is not listed, your edition of Excel may not support it.




