Forum Discussion
Copy/paste no longer working in Excel
- I’d recommend that everyone having thus issue goes to File > Feedback and send a frown, putting your details in the section and start it [Can’t Copy Paste]
Also what version is everyone in who’s having this problem ? File > Account
It will read something like
Semi Annual Channel
Build 1234.567
As a novice user I think I have the same problem. I am trying to copy a range of cells in a column to the adjacent column ( ie next month). I used to be able to do this with one mouse operation - select the cell range then move over to the next column and it would copy that range. Now that doesn't work. It changes the content of each selected cell to the first (top) cell. This is definitely something that has changed or a parameter that I've changed but I don't know what.
No, it's one seamless mouse operation. I position the mouse on the bottom right corner of the top cell to be selected then move the mouse down to select the required cells, At the bottom cell I move the mouse over to the adjacent column and it should copy the old contents into the new column. Now it copies the contents of the top cell into all the lower cells and doesn't attempt to copy them into the adjacent column. The cursor displays a bold cross and doesn't change shape when selecting cells or trying to move the cells. It used to display a different cursor during this copy operation.
I think you need to highlight first then drag across from the corner
Wyn HopkinsWhat is shown here in the very short video is NOT Copy & Paste. It is simply a copy. The Copy & Paste function in Excel is the most powerful of all applications, and when it works it gives the user a whole range of options when you paste. These include to copy only the formula, or value(s) only and to leave the format alone, or copy only the format and leave the values alone, or do a Paste Link, which stores an Excl type address from another set of cells or from another worksheet. This is what is use very often, and this and all the other options, other that 'text' is lost pom the Paste when Excel is not working correctly. As stated elsewhere, sometimes Cntrl C for the copy will work (instead of a right click and then selecting 'Copy'), although you may have to hit Ctrl C many times before the dashes that surround what you are copying will stay there. If the dashes to not stay there, then the Paste will be 'Text' only. This is a definite bug in Excel.
Vincent (01-16-2021)