Fix Excel for Mac Multiple Selections Error When Copying Cells
Question details
The user needs to resolve a multiple-selections error when copying cells between Excel workbooks on a Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Copying cells between workbooks, with no macros or hidden rows identified in the affected workbook.
- Observed behavior
- Excel displays “This action will not work on multiple selections.” Related workbook issues can include worksheets that cannot be deleted or incorrect print areas.
Open the source and destination workbooks and identify the cells you want to copy. Check whether the problem also occurs when copying a simple range between two new, blank workbooks.
Test Worksheets One at a Time in a New Workbook
Use this method to identify whether a particular worksheet or the original workbook structure is associated with the error.
In Excel, select File > New Workbook and leave the affected workbook open.
Right-click the first worksheet tab in the affected workbook and select Move or Copy. Choose the new workbook as the destination, select Create a copy, and confirm.
In the new workbook, select a continuous range on the copied sheet and use Edit > Copy and Edit > Paste to test it.
Use Move or Copy to add each remaining worksheet one at a time, testing cell copying after each addition. Note which sheet is added immediately before the problem appears.
If a particular sheet appears to trigger the issue, create a fresh sheet with the plus button and try copying its needed cells in smaller continuous ranges. Check formulas, formatting, and print settings in the rebuilt sheet.

Check the Selection and Hidden Rows or Columns
Use this check to rule out nonadjacent selections or hidden cells before rebuilding the workbook.
Troubleshoot Excel When Every Workbook Is Affected
Use this approach if the same error occurs in new, blank workbooks as well as the original file.
Work With Excel Files in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working in WPS to make switching between office suites easier; it does not repair an Excel installation.

Frequently Asked Questions
Why does Excel say I have multiple selections when I am copying cells?
The selection may contain nonadjacent ranges or hidden cells, but a worksheet or workbook issue can also be involved. Select one continuous range and check for hidden rows or columns before testing the sheet in a new workbook.
How can I find the worksheet associated with the error?
Create a new workbook, then right-click each source sheet tab and use Move or Copy with Create a copy selected. Test cell copying after adding each sheet.
What if Excel will not delete or copy a worksheet?
Check workbook structure protection under Review. If Move or Copy still does nothing, try creating a new sheet and copying the needed cells in smaller continuous ranges.
What should I do if the error appears in every workbook?
Test copying in a new blank workbook, then select Help > Check for Updates in Excel. If the problem persists, contact Microsoft Support for help troubleshooting Excel for Mac.




