Fix: This Action Won't Work on Multiple Selections Excel Error

The This action won’t work on multiple selections error typically appears when you try to execute an action that is not supported or incompatible with multiple selections in Excel.

In this guide, we will explore the causes behind this error and provide solutions to help you overcome this issue. Let’s get started.

What can I do if this action won’t work on multiple selections?

Before we go to the advanced fixes, here are a few preliminary checks you should do:

• Restart the computer.
• Save and exit the Workbook and open it again to perform the action.

Once done, follow the methods mentioned below to fix and avoid the issue.

1. Make the selections properly

1. Select the data you want to copy on the other sheet.
2. Go to the destination sheet, right-click, and select Paste Special.
3. Now choose All to paste the values with formulas.
4. Click OK to confirm the choice.

To avoid this multiple selections error, you need to ensure the selections should be from the same columns or rows.

Check all the sheets on the Workbook to ensure that the data on all the sheets apart from the one you want is unselected.

Also, while pasting the values from multiple regions, and want to copy & paste the formulas as well.

2. Use the Clipboard to paste the data

1. Click Clipboard.
2. Select the data from the desired columns and rows. If the rows and columns are not intersecting, we suggest you repeat the action to add all of them to the Clipboard.
3. Once all the values are on the Clipboard, go to the sheet where you want to paste the values. You can either click Paste all to them or click on them one by one and paste them on the sheet.

3. Ungroup the sheets

1. Right-click a sheet tab and click Select All Sheets on the Excel workbook.
2. Now right-click any sheet tab, and choose Ungroup Sheets.

3. Create a new copy

1. Right-click a sheet tab and click Select All Sheets on the Excel workbook.
2. Now right-click any sheet tab, and choose the Move or Copy action.
3. You will receive a prompt; select (new book), then place a checkmark next to Create a copy box and click OK.

In Excel, an action might fail on multiple selections because some operations only work on single cells or ranges.

If the selected cells have different data types, like numbers and text, it can confuse Excel. Certain features also have limits that prevent them from applying to multiple selections, and mixed formula references can cause conflicts.

So, these are the causes and the solutions that can help you address This action won’t work on multiple selections error message in Excel, allowing you to work efficiently with numerous cells or ranges and accomplish your tasks effectively.

If you are facing issues like Excel not opening on Windows 11, we suggest you check out this informative guide to fix it.

Please feel free to give us any information, tips, and your experience with the subject in the comments section below.