HomeFixesHow to Fix Microsoft Excel Cannot Paste the Data Error on PC...

How to Fix Microsoft Excel Cannot Paste the Data Error on PC or Mac

Author

Updated On

Reading Time

Microsoft Excel is a lifesaver when you want to organize all your data, values, and information. With each cell arranged in columns and rows, you can customize it in a way that fits your preference and style.

However, you may encounter errors when you want to paste values on a Microsoft Excel cell, workbook, or datasheet. It seems that there are instances when you receive an issue indicating that you cannot paste the data on the spreadsheet.

The error occurs when copying a range of data from one Excel workbook to another or from a notepad on Windows 10 PC or Mac computer. If you right-click the copy-paste feature is simply not working.

Fixing-Microsoft-Office-365-Cannot-Paste-the-Data-Error-on-Excel

While it is frustrating, especially if pressed in time, you can fix the problem with a few troubleshooting methods.

To repair corrupted Excel spreadsheets you can use the last backup or restore to the previous stable copy of the file, or try to use Recovery Toolbox for Excel. With a very high probability, Recovery Toolbox for Excel can return data .xlsx files to their original state before they were damaged.

DON’T MISS: Latest deals on new Windows laptops at Amazon & Walmart!

Fixing Microsoft Office 365 Cannot Paste the Data Error on Excel

Microsoft Excel issues are common to a lot of users on Office 365 & desktop apps. But, it does not mean that you cannot do anything about it. Follow each of the solutions below to resolve and fix the “Cannot Paste the Data” error on your Excel sheets.

Method #1 – Restart your Microsoft Excel App

  • Save the changes you made on your Excel file.
  • Exit the Microsoft Excel app and wait for a few moments.
  • Relaunch the app and open the file again.
  • Try to paste the data.

Method #2 – Edit the MS Excel Cell Format

  • Select the column heading that you want to change.
  • Go to the Home tab.
  • Select Number Format.
  • Choose the format that best fits the data that you are trying to paste. For instance, if it is a date, change the format to Date.

Method #3 – Add a New Column or Row

  • Highlight the number of rows or columns that you want to add.
  • Go to the Home tab.
  • Click the Paste button.

Method #4 – Use the Excel Paste Special Function

  • Go to the cell where you want to paste the data and right-click on it.
  • Select Paste Special.
  • Click OK.

Method #5 – Unmerge the Cells

You may be trying to paste the information on merge cells, which is not possible if the data comes from a regular cell. Try to unmerge the cells first before pasting the data.

  • Highlight the cells where you want to paste the information.
  • Go to the Home tab.
  • Click Merge and Center.
  • Select Unmerge Cells.

That’s it! You can try these solutions and check if you can paste the data on your Microsoft Excel file now.

Do you have other methods that have worked in resolving the Microsoft Excel pasting issue? You can share them with our users in the comment section below.

Windows Dispatch is a website supported by its readers & community. Some pages may contain affiliate links which may allow us to earn a little money when you buy through them.

Eddie Mendoza Jr
Eddie Mendoza Jr
Eddie has a degree in Information Technology with a natural inclination towards troubleshooting devices. With more than 10 years of blogging experience in different niches, he has found it most satisfying when writing easy-to-follow guides and simplified articles related to computers, smart TVs, mobile devices and Internet-based services.

Further Readings

1 COMMENT

  1. I just had this happen to me. We had been entering ASCII code ATL 26 and accidentally used the numbers across the top of the keyboard instead of the number pad to the right. I simultaneously pressed ALT+2+6 again and it worked. I have no idea what I did but the problem was solved.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Trending