Office for Mac Issues

Fix Excel for Mac Multiple Selections Error When Copying Cells

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

The user needs to resolve a multiple-selections error when copying cells between Excel workbooks on a Mac.

Fix the Multiple Selections Error When Copying Cells in Excel for 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a new workbook

In Excel, select File > New Workbook and leave the affected workbook open.

2
Copy the first worksheet

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.

3
Test cell copying

In the new workbook, select a continuous range on the copied sheet and use Edit > Copy and Edit > Paste to test it.

4
Repeat for each sheet

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.

5
Rebuild the affected sheet if needed

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.

Test Worksheets One at a Time in a New Workbook
If Move or Copy does nothing: Check whether the workbook structure is protected under Review. If the command still fails, try copying needed cells to a new sheet in smaller ranges instead.
Free Microsoft Office alternative

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.

Copy and paste spreadsheet ranges using familiar controlsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for a smoother move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.