Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range (Copy-paste clipboard persistence)
If I copy [ctrl-c] a cell, then type in another cell, then try pasting, no result. No paste. It would be nice if Excel would maintain the copied data on the clipboard even after the dancing ants no longer appeared, so that I could paste that data.
(2015-11-05 Dan [MS] - updated idea title and description to be clearer)
Starting with the Excel release available in June, Excel “Keeps” your copy longer. You can Copy your cells, and before you paste, you can still do other tasks like typing or inserting cells.
Based on customer feedback, the dotted “Marquee” stay active for much longer so that you can type, add formatting or many other things before the paste operation. We also made both the “Insert” and “Insert Copied Cells” commands available after the copy operation. Now, if you are copying data to another worksheet, only to realize you need more room, you can insert a variable number of cells and then paste without having to re-copy the original range!
If you want the Marquee to disappear, you can use the ENTER key to perform the paste operation, or after the paste, you can press the ESC key to cancel the copy.
Andrew Hunter commented
Is there keyboard shortcut to insert newlines when you have some data stored in your clipboard? Before this change in clipboard's behaviour, inserting new lines after a "copy / insert copied cells" operation was pretty much safe (because clipboard was cleaned after CTRL+ was pressed the first time).
Now you MUST remember to click ESC after having inserted copied cells and pressing again CTRL+, otherwise you'll paste millions of unwanted cells.
So, what's the best way to insert (empty) new lines in a sheet when you have something stored in your clipboard, using just your keyboard?
Thank you very much!
Seumas - Myself and others (Sharon & Shawn below) have experienced the Ants Marching, that won't go away. If I copy a section, paste it somewhere, then move to another cell to edit, my ants are still marching around my original copy selection. I must hit ESC to get the Ants to stop. I understand, that the ants are just indicating what is on the clipboard - but this feature should have a toggle (so we can turn it off)
I think there is some confusion here. Leigh said " that selection stays highlighted, even after a paste and editing other cells, the original COPY selection remains lit with the Ants marching". This is not the case for a standard installation of 2007, 2013, or 2016. Whatever cell in the workbook one copies, as soon as anything is done (selecting to edit a cell for example) the buffer is lost.
Some of us want to see the cell-paste buffer for Excel maintained until next overwritten.
Some of us would want to see the cell text only paste buffer (however that is handled) also follow the same rules. A configurable option to use 'default buffer behaviour' (as now) is probably the safe option to create. Those of us who want this new long-like buffer can then undo that check-box.
I agree with Warren Ashton, PL, and Shannon. Please give us the option to turn this off. During the last 20 years of using Excel, I thought clearing the clipboard was a nice feature designed to avoid inadvertent pasting of data or formulae. Users were always able to paste multiple times if they (1) didn't edit a cell between pastings or (2) copied the cell contents rather than the cell.
Warren Ashton commented
PLEASE change this feature to eliminate the persistent highlighting of copied cells or give an easy way to turn this feature off. It's SO distracting and adds multiple clicks to what should be a quick copy/paste process. This is terrible for power users and light users alike. Change it please!
For god's sake, we at least need a flag so we can turn this option off. Nice try, but what a terrible move.
I agree with Shannon. This new feature is a nightmare for many of us. At least give us the option to turn this feature on or off. I have had to create a macro in my personal.xlsb to clear the cutcopymode after each paste event to get around this.
I understand people's frustrations with losing copied data that they want to paste multiple times, but since this issue has been seemingly "fixed" and the dancing ants never seem to go away now, it's been super frustrating to have ESC out of the dancing ants every. single. time. And it seems to be slowing down the program - scrolling is now choppy, switching between tabs is slower, etc. Is there a copy/cut option that allows you to opt out of this feature?
Ed Hansberry commented
I hope it the feature to try soon isn't the one in the Fast Ring right now. Causes issues with PowerQuery queries that are loaded to excel sheets.
I agree that the data should be maintained on the clipboard to enable multiple pasting instances. That should remain until a new CtrlCopy is done or you hit ESC) HOWEVER, that Ants marching does not need to remain selected forever! In excel now, when I copy... that selection stays highlighted, even after a paste and editing other cells, the original COPY selection remains lit with the Ants marching. This is distracting for most users that want to Cut/Paste and continue on making other changes, they don't need to have their copy selection highlighted forever.
This item would, I imagine, be related to the repeat action / undo action options. I admit I cannot for the life of me work out how to make the repeat action (paste and other cell / row changes) work consistently. I may be at fault, but i don't think Repeat is available for many actions, and I cannot work out why. (Dear admin - I shall create another request for Repeat action, but do tell me off and remove it, if it is I who just can't use the software!]. Thanks for listening MassiveSoft!
I am so pleased to be able to feedback re. Office Nice to Have's and Naughties to Report!!
This requested correction to copy and paste (as well as the user document buffer settings) is so much needed. Hooray!! Great news indeed! Can we please have this as an update Office patch (release notes isssued with it) rather than having to pay for it in some version un the future? I shall bet my last dollar that no user is going to complain of having a checkbox to unset/set in the settings for "Remember Copy/Paste buffer data until Copy buffer is emptied using 'Purge Copy buffer.' " The current behaviour has always been odd.
YES. Why should the user lose the copied data because they clicked something? I NEVER understood this design decision.
Steve Ward commented
Excel for Mac also exhibits this odd behaviour which I can't believe is intentional. I've seen some workarounds including https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/clipboard-contents-disappear-excel-2016-mac/fdc4a0be-26c8-4e9e-b8ec-e40751f1dae0?tm=1482536844267. Have also posted here https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10551432-maintain-copied-data-on-the-clipboard-even-if-the but the Mac thread isn't receiving as much attention as this one.
Bob Jones, AKA Cybertaz commented
The former behavior needs to be restored in the Mac version of Excel as well. Somewhere along the line it was suggested that you use the Clipboard Task Pane which has not been provided for Mac users who also have suffered the loss of the Scrapbook. The use of neither, however, should be necessary.
It's utterly ridiculous that when you copy anything then type something before pasting that the content of the clipboard is lost. I know of no other program - Microsoft or otherwise - that exhibits this behavior.
This is actually multiple issues, many of which appear to be that the copied range (dancing ants) is cleared when performing other actions in a workbook.
1) When cells are copied the right click menu should have BOTH "Insert..." and "Insert Copied Cells..." because using Insert Row from the Ribbon clears the clipboard
2) Insert Row should not clear the copy selection
3) Clearing a filter should not clear the copy selection
4) Function ___ should not clear the copy selection
The issue I have is that I will usually copy a value from a pivot table to then go browse over to the underlying data intending to filter with the copied value. That underlying data is sometimes ALREADY filtered, and when I clear the filter, it clears my copied range.
RE: CUT FUNCTION
I'm happy with how cut currently works in regards to dimming the data being cut until it is moved elsewhere. This is consistent with how Windows works in regards to file management as well. In terms of data/file integrity, Cut data/files should never "disappear" until they are pasted. What if you accidentally 'Cut' two files in a row, separately? The first one would just be gone. Same with a data range.
Yes, it used to be persistent but now it is not. Very frustrating.
This would be great, especially if it worked across any changes, including inserting rows or columns. I often copy some cells, realize I need to insert some rows before pasting, but then find that the clipboard has been flushed by the insert action.
It would also be nice to add a paste option following a Copy that allows for cloning the selected cells (like the Paste in Cut -> Paste does, which is different from how Paste works in Copy -> Paste).