Re: Copy/paste no longer working in Excel Try starting Excel in safe mode (press the control key immediately after starting Excel, it should pop up a confirmation dialog to ask whether you want to start in safe mode). If that makes your problem go away, the cause is very likely either an add-in or your personal macro workbook.
So, make sure to check the background processes before copying data from an Excel Sheet and close the “Macro Express” application. If you’re trying to paste special graphics from one Excel sheet to the other, you won’t be able to do it using the traditional “Paste” option.
Another thing we wanted the answer to was, why can’t I copy and paste from multiple Excel files?
These options appear only in the Excel Paste Special dialog box. Cause This behavior occurs because Excel cannot use its internal copying functionality when you run multiple instances of Excel. Instead, Excel relies on the Windows Paste Special dialog box for its copying functionality.
In this article, we will give you an overview of the cannot paste Error and how to fix Excel file cannot paste error with a reliable Excel repair tool. Overview of Excel file cannot paste the data Error.
Why can’t I paste a number in Excel?
On the Home tab, click the Number Format menu. Click the cell format that matches the information that you are trying to paste into the column. Cause: There are not enough columns to accept the information that you’re trying to paste. Solution: Insert more columns, and then try pasting again.
Cause: The information that you are trying to paste does not match the cell format (Date, Currency, Text, or other format) for the cells in the column.
How do I copy and paste a cell in Excel?
On the Home tab, click Paste. Solution: Select a range of cells for the Paste area that’s the same size and shape as the copied data. Select a range of cells that is the exact number of rows and columns as the information that you want to paste. On the Home tab, click Paste.
How to avoid copy and paste errors when selecting cells?
When you’re selecting the cells, be sure to select regions that are: Even one wrong cell will cause that error message! So, be sure that each selection includes exactly the same rows or columns. The next example, won’t cause Excel copy and paste problems, because both selections are in columns A: C.