May 2017 update which keeps the copied item active in the clipboard
Regarding the issue of...It's part of the May 2017 update which keeps the copied item active in the clipboard even if you do things that would normally clear it, like typing in a cell, applying formatting, etc.
Pressing ESC will clear the marquee/dancing ants.
Why in the world would Microsoft and an extra step here. This is terrible. At least give us the option to turn off the function. Please change this back or give us the option. Very disappointed!
Keep the Copy was designed to improve the experience of copying content to your clipboard based on customer requests. Copy and Paste functionality is different in Excel than most other applications because results from formulas can change and due to the large size of worksheets. Since making the improvements there has been mixed feedback about the changes that we made and it is not up to our quality standards. Effective today, Keep the Copy will be removed from Excel until we have improved the quality and design of this feature.
Excel Program Manager
Eric, does this mean Keep the Copy is removed in Excel 2019?
Inserting the cut cells induces lots of mistakes. Let me insert the cell then paste.
Another reason to hate Microsoft.
Another satisified microsoft user commented
You_suck_microsoft. Every cut and paste operation is now so much more effort. Your entire programming staff should be caned once for each additional key stroke you have caused the end users of your garbage software with this "feature".
Hire some adults and not mindless children with the attention span of gold fish to do your new "features". Sorry-That statement is probably not fair to children or goldfish.
Frustrated User commented
Whats more frustrating is that they are NOT removing it from the clipboard - they are overwriting the clipboard with nothing (perhaps i'm naive and this is how you "remove" from the clipboard).
I still use windows gadgets, my favourite being clip-boarder. In my attached image it shows the content i first copied, then when you hit esc to clear the selection, excel overwrites the entry (interpreted as "empty"). Perhaps this is a quirk with clip-boarder in the fact that it retains everything sent to the clipboard but from my perspective Excel shouldn't be doing anything like this. At all. Ever.
This SU post https://superuser.com/a/623142/619873 quotes an Excel PM but as others have suggested, this is a cop-out answer.
While i'm here i'll also add how frustrating it is to copy content TO excel from another application - you have to double click. Once to get focus to excel, then once to click the cell you want to paste into (assuming you've not pre-selected the cell because you know this is going to happen). Excel should be intelligent enough to realise you've clicked focus onto a cell (google sheets doesn't have this problem! and that's IN BROWSER!). You'd think that a MS product on a MS OS could leverage certain functionality that FREE software could not. /shrug
I hate the way that excel uses the clipboard. I want it to work the way it does in every other software ever made. I don't want excel to do special extra things with the clipboard.
Bruce Morris commented
This problem has returned, but the feedback has been closed. How do we get it reopened?
Todd Hutchison commented
Something seems to have changed again now and it is worse than it was originally. Now, it looks like the insert function is again automatic and worse there is now not even an option to just go to the ribbon and click insert blank cells. I have to hit escape insert the blank cells and then go back and copy what I want to copy and insert.
this latest change is now truly a nightmare.
If I make a copy of say three cells in a different workbook and then try to insert blank rows in a new workbook the copied cells from the other workbook, will automatically spread across all the new inserted rows to infinity. I then have to delete the inserted rows. Escape the copied cells. Insert new rows and go back and copy the two or three cells that I wanted and insert them where I wanted them in the new rows. This is so ridiculous and beyond frustrating. I have no idea why they was ever changed, as has been stated so many times in this post, just give people the option of inserting blank cells or inserting copied cells and let us decide which one we want.
This is very poorly conceived and goes way beyond keyboard shortcuts for me. I frequently I/O data via the clipboard manipulating it in ways that are difficult to do in Excel (yes, there is such a thing). I do this at a prompt via:
powershell –command “get-clipboard | myCommand| set-clipboard”
If you're not familiar with the prompt (or powershell), no matter. This just takes some Excel data (on the clipboard), does something with it (via myCommand) and then puts it back on the clipboard. Functionally it's as if you modified it in Word (although I don't know why you'd do that) but you can try it yourself with copy-paste something from Excel to Word, modify it in Word, and then copy-paste back to Excel.
Previously I was able to paste the new/modified data back into Excel in one step but alas no longer. Now after executing the above command, returning to Excel, and then selecting the destination cell, the new additional steps are:
1. press Esc. Without doing this, pressing Ctrl-v or clicking on paste will simply place the original data.
2. ensure the clipboard is open in Excel
3. find my data (most recent at the top of the clipboard list) and click on it to paste it
Because I've just pressed Esc (which is required to clear the "dancing ants"), it's impossible to not have the clipboard open and simply use Ctrl-v instead (well that is w/o even more steps). The "brain-child" of this functionality is apparently too short sighted to have considered this. Further this forces me to use the mouse, which defeats the purpose of having shortcuts such as Ctrl-c and Crtl-v. Very poorly conceived.
Allowing us to Insert Copied Cells Multiple times without having to recopy was very useful for my particular job I would love this feature added back as an option
I agree with Silvia
This is not what I wanted!
I didn't like. Excel should give us the option to disable the feature.
I LOVED 'Keep the Copy.' I miss it so, so much. I work in Excel almost all day long, and it saved me so much time. I also hope it comes back very, very soon!
I stumbled upon this thread while searching Google for ways to keep my copy data persistent in Excel. I too wish for its return as soon as possible as it would improve my productivity greatly.
So how do I get rid of the Keep the Copy in my current version of Excel? Do I have to Delete and Re-install Excel?
As it happens, forcing all users into one option will disappoint half of them. Keeping Excel's copied cells active indefinitely is very dangerous when you are using Excel alongside different programs and you need to copy&paste back and forth from them.
Why Excel developers can't devise a way to enable/disable such a dangerous feature? Perpetual license is becoming too dangerous an option for many
Please put this feature back in.... I thought it was the best feature to come along in a long time!!!
Help! I loved that I could copy multiple lines once in Excel and insert those copies in multiple places in the worksheet without re-copying each time. Removing the Keep the Copy function has DOUBLED my workload! PLEASE, give us the option to turn that function on or off!
J Piggott commented
Please bring this feature back! Or at least give us the option of turning it on?
I found the feature absolutely essential when copying certain 'templated' groups of cells, and needed to insert this template into several areas of the same worksheet.
keridwen cheetham commented
This drove me nuts. Excel kept crashing when complex formulae were sudden pasted into a complete row when I just wanted to add a blank row. I appreciate that may be different from, say, Word but Word and Excel are used in wholly different ways. I subscribed to the thread so saw I was in no way alone. I’m very, very happy it’s been turned off.
The thread now seems to be used by people who want it turned on so I’m seeing all those messages.
I think it highlights the need for things this fundamental to people’s daily usage of the software to be made optional when they are introduced.