Microsoft Excel is an utility developed by Microsoft and is normally used to arrange data and carry out monetary evaluation; it’s used throughout all enterprise features and enormous and small firms. Microsoft Excel may be very helpful to our lives, however typically errors can happen, particularly if you wish to paste values on an Excel cell, workbook, or datasheet and also you cannot paste data.
Why is my paste not working in Excel?
The Microsoft Excel error normally happens when attempting to repeat a variety of data from one Excel workbook to a different, so it’d trigger an error that stops you from pasting data into the workbook. One other chance is that you’ve got locked cells in your Excel sheet, which might stop you from pasting data into them. You’ll be able to verify to see if any cells are locked by clicking the Overview tab and clicking Defend Sheet. If any cells are locked, you’ll be able to unlock them by deciding on them after which clicking on Unprotect Sheet.
Why can’t I paste data from one Excel to a different?
When you cannot paste data from one Excel workbook to a different is because of:
- The data that you just wish to paste doesn’t match the cell format for the cells in the column; If you wish to paste a considerable amount of data into your workbook, be certain that the format in your columns matches the format of the data that you just wish to paste.
- There usually are not sufficient columns to just accept the data you are attempting to paste, so insert extra columns and attempt to paste once more.
- The copy space and the paste space usually are not the identical measurement and form, so choose the upper-left vary as a substitute of the complete vary earlier than you paste the data into the cell.
Microsoft Excel cannot paste the data
Comply with the options beneath to repair the Microsoft Excel cannot paste the data error:
- Restart Excel
- Change the cell format
- Insert additional columns
- Use the Particular Paste function
- Unmerge the cells
1] Restart Excel
Save the adjustments in your Excel workbook.
Shut Excel and wait a couple of minutes.
Now, relaunch Excel and see if the error persists.
2] Change the cell format
Choose the column heading you wish to change.
On the House tab, choose the Quantity launcher in the Quantity group.
A Cell Format dialog field will open.
Select the format that matches the data you are attempting to paste.
3] Insert additional columns
Click on the column heading for the column to the proper of the place you wish to add a column.
On the House tab, click on the Insert button.
The columns you chose will shift to the proper, and the new column seems.
Repeat step till you will have inserted the variety of columns you need.
4] Use the Particular Paste function
Go to the cell you wish to paste the data advert right-click it.
Choose Paste particular.
A Paste particular dialog field will open.
Click on OK.
5] Unmerge the cells
You might be attempting to paste the data on merge cells; attempt to unmerge the cell earlier than merging data.
Spotlight the cells the place you wish to paste the data.
On the House tab, click on Merge and heart.
Choose Unmerge cells.
We hope this tutorial helps you perceive tips on how to repair Excel cannot paste the data error.
When you have questions on the tutorial, tell us in the feedback.
