A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
For Excel copy/paste issues on Windows, use this troubleshooting path:
- Check the paste target size and shape
- If the copied range and paste range do not match, paste can fail.
- Either select only the top-left destination cell before pasting, or select a destination range with the exact same number of rows and columns as the copied data.
- Make sure the destination has enough columns
- If pasting wide data, insert additional columns first, then paste again.
- Check cell format when pasting large amounts of data
- If large pasted content fails, make sure the destination column format matches the source data format.
- In Excel, select the column, go to Home > Number Format, and choose the matching format.
- If Paste Special is missing or not working
- Go to File > Options > Advanced.
- Under Cut, copy and paste, make sure Show Paste Options button when content is pasted is enabled.
- Test for add-in conflicts
- Third-party add-ins can block or interfere with copy/paste.
- Start Excel in Safe Mode:
- Find the Excel icon.
- Press and hold CTRL and double-click Excel.
- Select Yes to open in Safe Mode.
- If copy/paste works in Safe Mode, disable add-ins one by one until the conflicting add-in is found.
- Close web browsers and try again
- Browser processes can conflict with Paste Special in some cases.
- Close all browser windows, then test paste again.
- Avoid using multiple Excel instances for copy/paste
- If files are open in different Excel instances, Excel may not use its internal paste functionality correctly.
- Open both workbooks in the same Excel instance and try again.
- This is especially important if Paste Special options such as Formulas, Values, or Formats are unavailable.
- If automation or add-ins use clipboard operations
- Running multiple Excel instances in parallel while add-ins or automation perform clipboard copy/paste can cause errors or crashes.
- Avoid parallel Excel instances for clipboard-based tasks. If possible, use methods that do not rely on the clipboard.
If the issue is happening after an update and even basic cut/copy/paste fails in the same workbook, an Online Repair of Office was suggested in a similar case.
References:
- I can't copy and paste data on my sheet in Excel for Mac
- Paste Special option is missing or not working in Microsoft Office
- You cannot paste any attributes into a workbook in another instance of Excel
- Excel may crash when running multiple instances that use clipboard functionality programmatically
- After the latest update 1 June 25, I cannot cut and paste anything, even in the same document. Suggestions please. - Microsoft Q&A