Copy and Paste Not Working in Excel (9 Reasons and Solutions) (2023)

The most common actions we takeExcelThe data plate isCopy and paste.but sometimes problems can occur when we try to copy and paste. Therefore, this article will show you an effective way to solve the problemcopyIPasteYesTo serveexistssuperiority.

To demonstrate this, I will use a sample data set as an example. For example, the following data set representsproduct,price,how much, Meallcompanies.

DOWNLOAD THE WORKBOOK

For independent practice, download the workbook below.

9 Reasons and Solutions Why Copy and Paste Doesn't Work in Excel

Reason 1: Copy and paste 2 areas with one formula

We had problems whenever we wanted to copy and paste separate ranges of cells, inclofficiallyto the data set value. We noticed that only the values ​​were pasted, not the types included in them. So, even if we change the value of the cell present in the parameter, the result will not change.

solution:

Follow the steps to resolve this issue.

rhythm:

• First, select a range of cells to edit.

• Then select the cellG4Or anywhere else you want to paste.

• After that, right click and selectspecial pastefrom the context menu.

• A dialog box will appear, selectallfromPasteselection.
• then pressWell.

• As a result, you will get the desired result.

Read more:[FIXED]: Right click copy and paste not working in Excel (11 solutions)

Cause 2: An error occurred while copying different rows and columns in Excel

ExcelIt shows error when we copy different rows and columns. For problems see the steps below.

rhythm:

• First, as shown in the red box in the image below, select different rows and columns and try to copy.
• An error message will immediately appear.

solution:

This happens becauseExcelThe copy command does not work on different rows and different columns at the same time. The solution is as follows.

rhythm:

• Select any range of cells in a columnButIdoand copy them. It will work.

• Also, to select any cell in the row4,5,6, Me7and copy them. The above problems will not occur.

Read more:How to Copy Rows in Excel (4 Easy Ways)

Cause 3: Copy and paste the range size mismatch into Excel

Also, Excel will display an error if the copied and pasted ranges do not match. Follow the steps below to understand the issue.

rhythm:

• First select a columnButand copy it.

• Then select the cellF4and try to paste. An error message will appear.

solution:

Possible solutions are listed below.

rhythm:

• select the entire columneat.
• Then paste. You will get results.

Cause 4: Excel conditional formatting issues

Sometimes Excel does not allow copy and paste or slows down the process because of the applicationConditional formattingin the data table.

solution:

To learn how to fix the problem, see the steps below.

rhythm:

• First, chooseClear rules from the entire worksheetfromclear ruleschoices inConditional formattingdrop down list belowDomLet me underline.

• This will remove all formatting. Then save the file as a new file. Finally, you can copy and paste without any problem.

Read more:Paste only values ​​without formatting in Excel with VBA

similar reading

• Exchange (copy, import, export) data between Excel and Access
• How to Use a Paste Special Command in Excel (5 Cool Ways)
• Excel VBA copies rows to another worksheet based on conditions
• How to Copy and Paste Only Visible Cells in Excel (3 Easy Ways)
• Copy and Paste Precise Formatting in Excel (6 Quick Ways)

Reason 5: Excel DDE causes problems when copying and pasting

also,DDE(dynamic data exchange) option may cause problems when copying and pasting.

solution:

ignoreDDE(dynamic data exchange) can be solved"Excel cannot paste data'Question. Thus, the process of learning to ignoreDDE.

rhythm:

• Click firstdocument.

• Then choosechoices, you will find it in the lower left corner.

• Therefore, a dialog box will appear. in thereAdvanceduncheck the boxIgnore other applications that use dynamic data exchange(DDE).
• Finally pressWell.
• You will now be able to copy and paste regardless of this issue.

Read more:How to Copy Cells in Excel Using a Formula (7 Methods)

Reason 6: Copy and paste large amount of data in Excel

We know it traditionallyXLSThe leaves have65.000WELL. This creates problems when copying and pasting.

solution:

If you want to copy more, just go toXLSXbed sheet. There you will have a million lines for data entry.

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

Cause 7: The Excel add-in was disabled and enabled

Supplements can be frozenExcelwhen we try to copy and paste.

solution:

So follow the steps below to disable and then enable the plugin.

rhythm:

• at first, to openExcelfiles in safe mode.
• then go todocumentand selectchoices.
• As a result, a dialog box will appear. in thereaccessorycard, select itto go, which is next doorgovernBox.

• After that, to disable plugins, uncheck all plugins. After that, enable them again. Eventually the problem will disappear and you will be able to copy and paste without problems.

Read more:How to paste from Clipboard to Excel using VBA

Reason 8: Enable hardware graphics acceleration in Excel

sometimes activatedhardware graphics accelerationwill cause problems.

solution:

Disabledhardware graphics accelerationFreezes when copying and pasting data is resolved.

rhythm:

• Click firstdocumentand selectchoices.
• In the dialog box that appears, noteDisable hardware graphics accelerationand pressWell.

Reason 9: The computer needs to restart in clean boot mode

Also, rebootpersonal computerWhen in clean boot mode, it will appearExcelIs the sheet damaged?

solution:

So see below steps to reboot.

rhythm:

• First, chooseWindowsicon and searchjogging.
• Then enterconfiguration filefrom the insideOpenbox and pressWell.

• As a result, a dialog box will appear. in thereGenerallycard, remove the check markLoad startup itemsfrom the insideselective activation.

• after that goServinghere, check it outHide all Microsoft servicesand selectdisable all.

• After that, atruncard, select itopen the task manager.

• Finally, disable any startup process.

• Finally, back toSystem configurationwindow and pressWellSave the changes. After reboot it will reboot in clean modepersonal computer.

Read more:How to Copy and Paste in Excel and Preserve Cell Size (7 Examples)

Other possible solutions when copy and paste does not work in Excel

1. Restart the Excel workbook to fix the copy and paste problem

Sometimes it's just a matter of rebootingExcelWorkbooks can solve problems related to copying and pasting. So before going to other solutions, restart the workbook first.

2. Start Excel in safe mode

open oneExcelFiles in safe mode address issues where corrupted plugins prevent users from pasting data. launchExcelIn safe mode, first press and hold "control key' key and openExceldocument. A dialog box will appear, tapAnd.

3. Clear the cache file

Deleting overloaded cache files can solve freezing problems. Therefore, delete the cache files andExcelit will work fine.

4. Virus scan

sometimes,VirusI'm causing problemsExcelCopy and paste commands. Try to remove this malicious virus to solve the problem.

5. Installation and maintenance of the office

In other cases, repairing your office installation can solve copy and paste problems.

6. Disable the Macro Express application

Makro ExpressIsWindows basedApps running in the background can sometimes cause problemsExcel.So close this app to solve this problem.

in conclusion

From now on you will be able to solvecopyIPasteexistsExcelYesTo serveproblem with the above method. Keep using them and let us know if you have more ways to complete tasks. If you have any comments, suggestions or questions in the comment section below, don't forget to leave a comment, suggestion or question.

Relevant Articles

• VBA code to compare two Excel worksheets and copy the differences
• How to Copy Multiple Cells to Another Worksheet in Excel (9 Methods)
• Difference between Paste and Paste Special in Excel
• How to Copy Alternating Rows in Excel (4 Methods)
• Copy and Paste in Excel Without Formulas (7 Easy Tips)
• How to automatically copy rows in Excel to another sheet (4 methods)
• Disable copy and paste in Excel without macros (with 2 criteria)