Close & Reopen the Excel Workbook

There is a possibility that you can receive this error message due to glitches in the Excel app. Therefore, once you close & again open the application to get this action won’t work on multiple selections copy paste Excel error is fixed.

Restart Your PC

Apart from reopening the Excel program, you can also reboot your PC. Though it is one of the basic tricks that help to deal with minor as well as unexpected glitches in the PC.

To do this, you have to:

1. Go to the Start menu on your Windows desktop
2. Next, click on Power button
3. Finally, click on the Restart option
4. Now, wait until your computer gets restarted successfully to check for the error.

Make Selections Properly

1. First of all, select the information that you need to copy on another Excel sheet. Copy them by pressing CTRL
2. Then, go to the sheet where you want to paste the data, right-click there & select the Paste Special
3. After that, choose All in order to paste values with the formulas
4. Now, confirm the selection by clicking on OK.

Fix Excel This Action Won’t Work on Multiple Selections Using the Clipboard

1. On your opened Excel document, go to Home tab >> click Clipboard
2. Then, select the information from the chosen columns & rows. In case, if the rows & columns aren’t intersecting, then you can repeat the accomplishment to add all the data to a Clipboard
3. After this, go to a sheet where you need to paste all the values. Simply click on Paste All option to paste them on a sheet.

Create the New Copy to Fix Run Time Error 1004 This Action Won’t Work

1. First, right-click on the Sheet tab at the bottom >> click the option Select All Sheets from various options on Excel workbook
2. Then, right-click on any sheet tab >> choose on Move or Copy action
3. Now, you’ll get a prompt; choose the (new book) >> find Create a copy option then checkmark that box & click OK.