Easy Correction: How to deal with “Excel cannot stick data” error

. “I can’t paste the data” The error in Excel usually occurs when you copy a group of cells and try to stick them into an area that does not match the size or format. This can be annoying, especially when working with a large amount of data. . Good news This is to easily correct this problem by understanding what it causes and using the right solution.

Below are some common situations and how to correct them and a real example you can try in Excel.

The sample scenario that caused this error:

Let’s take an example of copying the data from three columns and sticking to a single column.

When I try to copy values B2: D4 and paste them into the cell E2Excel a ‘The data cannot be bonded ‘error.

How to fix this error?

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

Correction 1: Match the target range dimension

• Instead of just choosing E1: E2CLICK ONLY E1 (one cell).
• You can press the CTRL + V keys for paste.
• Now Excel will automatically stick the entire 3 × 3 block E1.

Notes: During the masts, always click on the upper left cell of the target area. Do not select a range of different sizes in advance.

Correction 2: Use the paste to convert the format

Sometimes this can cause a mistake mismatch formatting or Combined cells.

• You need to choose and copy the cells B2: D4.
• Right -click the target starting cell (for example, E1).
• Click the option Special paste.
• Select values ​​or values ​​and number forms, then click OK.

Paste of values ​​using the paste special option

Notes: This is useful if it contains welding formulas, combined cells or special formats that cannot be adhered directly.

Correction 3: Open the cells before copying or gluing

If it contains copied data Joined cellsThen the Excel application will throw you. I can’t paste the data Mistake.

• You can do it for test Combine the cells B2: C2.
• Then try copying values ​​from cells B2: D4 And paste them to other cells.

This causes error. To overcome the problem, you must first remove the cells and copy the values ​​of the cells.

• You should choose welding cells.
• Go now House Tab -> Click it Combine and Center -> Choose Leave the cells choice.

Challenging cells

• Now, you can copy and paste cell values ​​as usual.

Notes: Necessary Avoid combined cells In the tables or data clusters you plan copy Or analyze to prevent such an error.

Correction 4: Clean the filters before copying

If you are trying to copy and stick the values ​​of the cells applied by the filter, you may encounter this problem.

• First, you must transform the range B2: D4 CTRL + T to a table that uses.

Convert cell values ​​to a table.

• Then, you need to apply a filter to the column Product And just choose “Apple.“
• Now, copy visible data and try to stick it to another place.

Bonding values ​​at the position of new cells may not work properly Because only excel He copied visible filtered cells. You can solve this problem by following the steps below.

• Go to private option will use this temporary problem:
  • You should use the keyboard shortcut switch. Special Option -> Now, Only visible cells And finally, OK Button to complete the process.
  • Now, you can copy and paste values ​​into the new cell, you will not cause any problems.

Correction 5: Paste a new page

If none of the above solutions work for you, the problem sheet or forming.

• In the current current page tab, you must right -click and select it. Sting -> Choose Workplace -> Click OK button.

Right the page tab and select Add.

Now, you need to select a Workbook and click the OK button.

• This will open a new page:Sac 2“.

Sheet2 was created.

• On the new page, click the A1 cell and paste the copied data.

This method will work, especially when it is the original page. protection– hidden columnsor any strange formatting rules.

Correction 6: Use the keyboard shortcut instead of right -click paste

This error can be triggered by the background panel failure, so that you can use keyboard shortcuts such as CTRL + C and CTRL + V to copy cell values ​​and paste cell values.

General solutions to solve this error in Excel:

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

Restart #1 Excel file:

• Save currently the excel file that runs.
• Turn off the Excel application.
• Restart the Excel app and open the worksheet from the latest file list.

This process is simple but effective. Restarting the Excel application will solve most of the errors on the worksheets.

#2 Disable Macro Express app:

This problem usually occurs in windows. Macro Express App. To fix, check the background operations before Copying data from an Excel page and Turn off Macro Express app If he’s running.

#3 DDE ignore (dynamic data change):

Ignoring dynamic data exchange errors, Excel’s inability to stick the data error. Therefore, you must disable the dynamic data exchange (DDE) option.

• You should choose File And then choose Options.

Open Options from Excel

• In the Excel Options window, Developed Tab from the left menu.
• Go to general options settings.
• Now, to ignore other applications that use dynamic data change (DDE), you need to clean the approval box next to it.

The removal of the DDE approval box will correct this error in Excel.

You can solve this error somehow.

Use XLSX pages instead of #4 XLS:

If you are trying to copy a large amount of data, a Xlsx file in its place Old XLS Format. The reason for this is limited to XLS files 65,000 rows. So, if your data has more lines than that, probably “Excel cannot stick data“Mistake.

This is it.