Office for Mac Issues

Fix Excel 2016 for Mac Not Moving or Copying Worksheets

Natalie TaylorNatalie Taylor Nov 20, 2026 869 views

Question details

The user needs to move or copy worksheets in an Excel 2016 for Mac workbook.

Fix Excel 2016 for Mac Not Moving or Copying Worksheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Open a working copy

Open a copy of the affected workbook in a supported version of Excel for Windows.

2
Check compatibility

Select File > Info > Check for Issues > Check Compatibility and review the results for formatting-related issues.

3
Enable Inquire

Go to File > Options > Add-ins. Under Manage, select COM Add-ins, click Go, and select Inquire if it is available.

4
Clean excess formatting

On the Inquire tab, select Clean Excess Cell Formatting. Choose the active sheet or all sheets, then follow the prompts to save the changes.

5
Test the worksheet

Open the cleaned workbook in Excel for Mac, right-click the worksheet tab, and select Move or Copy to test it.

Check and clean excess formatting in Excel for Windows
Inquire availability: If Inquire is not listed under COM Add-ins, your Windows edition of Excel may not support it. Cleaning can remove excess formatting, so check the working copy before using it.
Free Microsoft Office alternative

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.

Open and work with Microsoft Excel XLS and XLSX filesManage worksheets in a familiar spreadsheet interfaceMove existing Excel workbooks to a lightweight Office alternativeUse WPS Office for free
microsoft office alternative - wps office

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.