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



RECOMMENDED: Download this tool to help you safely fix common Windows errors & automatically optimize system performance

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.


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

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.

STILL HAVING ISSUES? Try this tool to troubleshoot Windows errors and safely optimize system performance


More From

How to Enable & Use DNS over HTTPS (DoH) in Windows 11 Computer

Online protection minimizes the risk of hackers, malware attacks, and other threats to your Internet accounts and online activities. DNS over HTTPS or DoH...

How to Fix Verizon FIOS WiFi Not Working & Cellular Service Outage Issues

Is Verizon down? Many users have been complaining over Twitter that their Verizon FIOS and cellular service is not working or can't be connected...

How to Fix Paramount Plus App Sign In Issues on Roku Device

CBS All Access has been rebranded to the new Paramount Plus. If you have subscribed to CBS All Access, you will automatically see the...

How to Fix Voice Typing Not Working Problem on Google Docs App or Website

There are things in our minds that are better put in words than be forgotten later on. However, many people cannot seem to type...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected