[Fixed]: Right Click Copy and Paste Not Working in Excel (11 Solutions)

Get FREE Advanced Excel Exercises with Solutions!

While working with a large Microsoft Excel dataset, sometimes we see that the right-click copy paste does not work in Excel. This is a common scenario in MS Excel. Today, from our dataset, we will learn the reasons and twelve solutions for the right-click copy paste not working in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


11 Easy Solutions to Fix Right Click Copy and Paste Not Working in Excel

Let’s say, we have a dataset that contains information about several sales representatives of the Armani group. The Name of the sales representatives, their Identification Number, type of products, and the revenue earned by the sales representatives are given in columns B, C, D, and E respectively. Form our dataset, we notice that the right-click copy paste does not work due to some cases. We will fix those reasons by using keyboard shortcuts, Command Prompt command, Add-in Command, VBA Macros also, and so on. Here’s an overview of the dataset for today’s task.

Run a VBA Code to Solve the Right Click Copy and Paste Issue in Excel


1. Run a VBA Code to Solve the Right Click Copy and Paste Issue in Excel

While the right-click copy paste does not work, we can use a VBA Code to enable the right-click copy paste in Excel. Let’s follow the instructions below to fix this problem!

Steps:

  • First, Press Alt + F11 simultaneously on your keyboard.

Run a VBA Code to Solve the Right Click Copy and Paste Issue in Excel

  • After that, a window named Microsoft Visual Basic for Applications – Copy Paste Not Working will instantly appear in front of you. From that window, we will insert an Immediate Window from the View To do that, go to,

View → Immediate Window

  • Hence, a module named Immediate will appear in front of you. In the Immediate, write down the below VBA code,
Commandbars("Cell").Reset
  • Further, press ENTER on your keyboard and you will enable to fix the right-click copy paste option.

Run a VBA Code to Solve the Right Click Copy and Paste Issue in Excel

Read More: Excel VBA: Copy Cell Value and Paste to Another Cell


2. Use the Command Prompt Feature to Fix the Right Click Copy and Paste Error in Excel

In several cases, Microsft Access or Microsoft Excel shows a “copy paste not working” error. We can solve the error by using the Command Prompt to fix the right-click copy paste. Let’s follow the instructions below to learn!

Steps:

  • First of all, If you are using the Windows 8 or later version, go to the search bar and type Command Prompt. Hence, press on the Run as administrator option. You can do that in windows 7 or before from the start menu.

Use the Command Prompt Feature to Fix the Right Click Copy and Paste in Excel

  • After that, a command window named Administrator: Command Prompt will appear in front of you. From that command window, type sfc /scannow.

  • Further, press ENTER on your keyboard, and you will be able to solve the error.

Use the Command Prompt Feature to Fix the Right Click Copy and Paste in Excel

Read More: Copy and Paste is Not Working in Excel (9 Reasons & Solutions)


3. Apply the Task Manager Command to Solve Error in Excel

While the right-click copy paste does not work in Excel, you will use the Task Manager command to fix the error. Let’s follow the steps below to solve the error!

Steps:

  • First, press Ctrl + Alt + Delete keys simultaneously on your keyboard.

Apply the Task Manager Command to Solve the Right Click Copy and Paste in Excel

  • After pressing the key, select the Task Manager Then, the Task Manager dialog box pops up. From the Task Manager dialog box, go to,

Microsoft Excel → End Task

  • Hence, you will be able to fix the error.

Read More: Formula to Copy and Paste Values in Excel (5 Examples)


Similar Readings


4. Fix Right Click Copy and Paste Not Working Error While Copying Different Rows and Columns in Excel

Excel shows the right-click copy-paste errors when we copy different rows and columns. See the steps below to know about the problem.

Steps:

  • Firstly, select different rows and columns as shown in the red-colored boxes in the following picture and try to copy them. Hence immediately, an error message will pop out.

Fix Right Click Copy and Paste Not Working Error While Copying Different Rows and Columns in Excel

Solution:

This happens because the Excel copy command doesn’t operate on different rows and different columns at the same time. The solution is given below.

Steps:

  • Select any range of cells in columns B and C and copy them. It’ll work.

  • Additionally, select any cells present in rows 7, 8, 9, and 10 and copy them. The above-mentioned problem won’t arise.

Fix Right Click Copy and Paste Not Working Error While Copying Different Rows and Columns in Excel

Read More: How to Copy Rows Automatically in Excel to Another Sheet (4 Methods)


5. Remove Conditional Formatting to Fix the Error in Excel

Sometimes, Excel doesn’t allow copying and pasting or slows down the process due to the application of Conditional Formatting in the datasheet. To learn how to clear the issue, see the below steps.

Steps:

  • First, from your Home tab, go to,

Home → Styles → Conditional Formatting → Clear Rules →  Clear Rules from Entire Sheet

  • Hence, it’ll remove all the formattings. And then, save the file as a new file. Finally, you’ll be able to copy and paste without any issues.

Remove Conditional Formatting to Solve the Right Click Copy and Paste Not Work Error in Excel

Read More: How to Copy and Paste in Excel Using VBA (7 Methods)


6. Use the Add-in Command to Fix the Error in Excel

We can solve our problem by using the File ribbon option. This is an easy and time-saving way also. Let’s follow the steps below to fix this problem!

Step 1:

  • First, press on the File option.

Use the Add-in Command to Fix the Right Click Copy and Paste in Excel

  • After clicking on the File ribbon, a new window pops up. From that window, go to,

More → Options

Use the Add-in Command to Fix the Right Click Copy and Paste in Excel

Step 2:

  • After pressing on the Options menu, a dialog box named Excel Options will appear in front of you. From that dialog box, firstly, select the Add-in Secondly, check the Go box from the Manage option.

  • Subsequently, to disable the add-ins, uncheck all of them. After that, enable them again. Finally, the issue will disappear and you can copy and paste without any issues.

Use the Add-in Command to Fix the Right Click Copy and Paste in Excel

Read More: How to Copy Data from One Cell to Another in Excel Automatically


Similar Readings


7. Modify the System Configuration to Solve the Problem in Excel

Moreover, rebooting the PC in a clean boot state will show you if the Excel sheet is corrupted or not. So, see the steps below to reboot.

Steps:

  • First, select the Windows icon and search for Run.
  • Then, type msconfig in the Open box and press OK.

Modify the System Configuration to Solve the Right Click Copy and Paste Problem in Excel

  • As a result, a dialog box will pop out. There, under the General tab, uncheck the Load startup items in the Selective startup.

  • After that, go to the Services Now, check to Hide all Microsoft services and then select Disable all.

Modify the System Configuration to Solve the Right Click Copy and Paste Problem in Excel

  • Subsequently, in the Startup tab, select Open Task Manager.

  • At last, disable each and every startup process.

Modify the System Configuration to Solve the Right Click Copy and Paste Problem in Excel

  • Finally, go back to the System Configuration window and press OK to save the changes. It’ll reboot in clean mode after you restart your PC.
  • Further, you will be able to fix the error.

Modify the System Configuration to Solve the Right Click Copy and Paste Problem in Excel

Read More: How to Copy and Paste Thousands of Rows in Excel (3 Ways)‌


8. Apply the Paste Special Feature to Fix Right Click Copy and Paste Not Working in Excel

We all have faced problems whenever we want to copy and paste the separate ranges of cells including Formulas in the dataset values. We notice that only the values get pasted but not the formulas involved in them. For this reason, the result doesn’t change even if we change the cell values present in the argument. Follow the steps to get rid of this issue.

Steps:

  • First, select the range of cells B4 to E7 and B13 to E14 to work with.

Apply the Paste Special Feature to Fix Right Click Copy and Paste Not Working in Excel

  • Then, select cell G4 or any other cell from your dataset where you want to paste.

  • After that, right-click on the mouse and select Paste Special from the context menu.

Apply the Paste Special Feature to Fix Right Click Copy and Paste Not Working in Excel

  • After clicking on the Paste Special option, instantly a dialog box named Paste Special pops up. From the dialogue box, select All from the Paste At last, press OK.

Apply the Paste Special Feature to Fix Right Click Copy and Paste Not Working in Excel

  • As a result, you’ll get your desired output.

Read More: Difference Between Paste and Paste Special in Excel


9. Ignore Dynamic Data Exchange to Fix Right Click Copy and Paste Not Working in Excel

Additionally, the Dynamic Data Exchange(DDE) option can create problems during copying and pasting. Ignoring Dynamic Data Exchange(DDE) can solve the ‘Excel cannot paste data’ issue. Hence, learn the process to ignore DDE.

Steps:

  • First, click File.

Ignore Dynamic Data Exchange to Fix Right Click Copy and Paste Not Working in Excel

  • Hence, select Options, which you’ll find on the bottom-left side.

  • After that, a dialog box will pop out. There, in the Advanced tab uncheck the box Ignore other applications that use Dynamic Data Exchange (DDE). At last, press OK. Now, you’ll be able to copy and paste ignoring this issue.

Ignore Dynamic Data Exchange to Fix Right Click Copy and Paste Not Working in Excel

Read More: How to Copy the Same Value in Multiple Cells in Excel (4 Methods)


Similar Readings


10. Restart Your PC to Fix the Problem in Excel

The most easiest and time-saving way to fix the right click copy paste in Excel is to restart your PC. Let’s follow the instructions below to learn!

Steps:

  • First of all, press right-click on the start menu and a window will appear in front of you. From that window, go to,

Shut down or sign out → Restart

  • After restarting your PC, you will be able to fix the copy paste error.

Restart Your PC to Workout the Right Click Copy and Paste Problem in Excel

Read More: How to Copy Multiple Rows in Excel Using Macro (4 Examples)


11. Solve the Right Click Copy and Paste Problem with Excel VBA

From our dataset, we will fix the right-click copy paste by using a simple VBA code. It’s very helpful for some particular moments. Let’s follow the instructions below to learn!

Step 1:

  • First of all, select the continuous data rows that you want to select from your dataset, and then from your Developer tab, go to,

Developer → Visual Basic

Solve the Right Click Copy and Paste Problem with Excel VBA

  • After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Copy Paste Not Working will instantly appear in front of you. From that window, we will insert a module for applying our VBA code. To do that, go to,

Insert → Module

Step 2:

  • Hence, the Copy Paste Not Working module pops up. In the Copy Paste Not Working module, write down the below VBA
Sub Copy_Paste()
CommandBars("Cell").Reset
CommandBars("Row").Reset
CommandBars("Column").Reset
End Sub

Solve the Right Click Copy and Paste Problem with Excel VBA

  • After that, run the VBA To do that, go to,

Run → Run Sub/UserForm

  • After running the code, you will be able to solve the right-click copy paste error.

Solve the Right Click Copy and Paste Problem with Excel VBA

Read More: Excel Formula to Copy Text from One Cell to Another Sheet


Things to Remember

👉 Sometimes, Virus causes issues in Excel copying and pasting commands. Try to remove that malicious virus in order to solve the problems.

👉 If a Developer tab is not visible in your ribbon, you can make it visible. To do that, go to,

File → Option → Customize Ribbon


Conclusion

I hope all of the suitable methods mentioned above to fix the copy paste not working error will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo