Easy repair: How to deal with “Excel Error cannot be paste” data “

the “Data cannot be paste” EXCEL error usually occurs when copying a group of cells and trying to glue them into a space that does not match size or coordination. This can be annoying, especially when it works in large quantities of data. the Good news It is that you can easily fix this problem by understanding its cause and using the right solution.

Here are some common situations and how to fix them, along with a real example you can try in Excel.

An example scenario causes this error:

Let’s take an example as the copy of the data of three columns and paste it in one column leads to this error.

project	amount	price
apple	50	$ 1.2
orange	30	$ 1

When I try to copy the values ​​from B2: D4 And paste them into the cell E2Excel ‘appearsData error cannot be pasted.

How to fix this error?

YesThis can be fixed. You may need to make some changes or deal with cell values ​​differently. Some of the possible repairs listed below.

Fix 1: Matching the size of the destination

• Instead of choosing only E1: E2Just click on E1 (One cell).
• You can click CTRL + V to paste.
• Now, the Excel will automatically glue the 3 x 3 block starting from E1.

Note: Always click on the upper -left cell of the targeted area of ​​the paste. Don’t conclude a different range.

Fix 2: Use Paste Special to convert coordination

Sometimes, this error can occur Incompatible or Cell cells.

• You need to choose and copy cells B2: D4.
• Right -click on the start of the destination (for example, E1).
• Click the option Special paste.
• Choose values ​​or values ​​and numbers formats, then click Yes.

Paste the values ​​using the special adhesive option

Note: This is useful if the source contains compact formulas, cells or special formats that cannot be affixed directly.

Fix 3: Unpinitely cancel the cells before copying or paste

If the copy data contains Cells compactThen it will throw you Excel application Data can not be pasted mistake.

• For testing, you can Merge cells B2: C2.
• Then, try to copy the values ​​of cells B2: D4 And paste them into other cells.

This will cause error. To overcome the problem, you should need to separate cells first and copy cell values.

• You need to choose Source cells.
• Now, go to house Tab -> Click Mercy and center -> Determine Cell off option.

Annoying cells

• Now, you can copy the cell as usual.

Note: you need to Avoid compact cells In tables or data sets you plan Copy Or an analysis to prevent this type of error.

Fix 4: Wiping filters before copying

If you are trying to copy and paste values ​​from the cells that are applied, you may face this problem.

• First, you need to convert the range B2: D4 To a table using Ctrl + T.

Convert the cell values ​​into a table.

• Then, you need to apply a filter to the column project Just set “apple.“
• Now, copy the visual data and try to paste it elsewhere.

Paste the values ​​on the site of the new cells You may not work properly Because only excellence Video visible visible cells. You can fix this problem by following the steps below.

• Using the option to Go to Special will repair this temporary problem:
  • You need to use the F5 keyboard shortcut and you need to choose private Option -> Now, select Visible cells only Finally, click Yes A button to complete the process.
  • Now, you can copy the values ​​and paste them into the new cell, will not cause any problems.

Fix 5: Paste on a new paper

If none of the above solutions succeed, the problem may be with Binding or Coordination.

• On the current paper tab below, you need to right -click on it and choose Entered -> Determine Worksheet -> Click Yes button.

Right -click on the paper tab and choose an insert option.

Now, you need to choose a worksheet and click the “OK” button.

• This will open a new paper called “Paper 2“.

Sheet2 was created.

• In the new paper, click on the A1 cell and paste the copy data.

This method will work, especially when the original paper is protectionand Hidden columnsOr any stranger Coordination rules.

Repair 6: Use the keyboard shortcut instead of the dough with the right mouse button

This error may be turned on due to the defects in the background, so that you can use keyboard shortcuts such as CTRL + C and CTRL + V to copy the cell values ​​and paste the cell values.

General solutions to fix this error in Excel:

The solutions below are general and are not based on the values ​​in the cells.

#1 Run the Excel file:

• Save the Excel file currently work.
• Close the Excel app.
• Restart the Excel app and open the worksheet from the list of modern files.

This process is simple but effective. The restarting of the Excel app will solve most of the errors that occur in the worksheets.

#2 Macro Express: 2 Macro Express:

This problem often occurs on Windows if you are running a file Macro Express app. To fix it, check the background operations before Copy data from Excel Paper and Close the Macro Express app If it is running.

#3 Ignore DDE (dynamic data exchange):

Ignoring dynamic data exchange errors will lead to a repair, Excel cannot paste the data error. Therefore, you need to disable the dynamic data exchange option (DDE).

• You need to choose file Then choose Options.

Open options from Excel

• In the Excel Options window, you need to choose advanced The tab of the left menu.
• Pass down to the general options settings.
• Now, you need to wipe the selection box next to ignoring other applications that use dynamic data exchange (DDE).

Cancel the DDE selection box will suit this error in Excel.

This is how you can fix this error in some way.

#4 Use XLSX papers instead of XLS:

If you are trying to copy a large amount of data, it is better to use XLSX File instead of The oldest xls format. This is because XLS files are limited to 65000 Rows. So, if your data contains more rows, then you can see “”Excel cannot paste data” mistake.

That’s it.