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

Date

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.

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.

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

Related

More From

How to Fix Dell HID Touch Screen Device Driver is Missing or Not Available

There is better control in using a touch screen than a keyboard. You can appreciate mobility and speed in performing tasks on your computer...

How to Fix Zoom Server Connection Error Code 104101, 104103 or 104114

Seeing error codes 104101, 104103, or 104114 when you try to connect on Zoom on Windows 10 computer would only mean there is a...

Fix Windows 10 File Explorer Search Not Working Properly

Searching anything in your computer is easier thanks to Windows Search. In this feature, you can easily access your files, videos, apps, and computer...

How to Fix Roblox Error Code 279 ID=17 or 277 Server Connection Failure

Roblox opens up an online world of possibilities and creativity through a video game. Enter a new dimension that will enhance your artistic mindset...

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

Stay Connected

Trending