Copy mode in Excel stays active
When you copy in Excel, the cell gets highlight. And when you edit any other cell, it gets back to normal and you can't paste anymore. But for me, the cell stays highlight and I still can paste it.
For VBA user : CutCopyMode won't go to False as it should when I edit any other cell.
I have the same behavior with cut.
It's annoying as I have a bunch of cells which stays highlighted. How can I bring back the normal way Excel works?
55 Answers
See the release notes for May 2017 'Keep the Copy'. A really annoying 'feature' and looks like no way to disable yet.
1Hitting the "Esc" key should remove the copy/cut selection around those cells.
Closing and reopening Excel should work if this issue persists.
2It's a new feature in the last Office 365 update. It seems there's no way to go back for now.
2Yeah it seems like something that happened in the latest update. Had to set cutcopymode to false in a bunch of my macros. Pretty annoying.
1Confirm it is still present in the latest Excel 365.
You need to press Esc, or press Enter instead of using mouse.
Although I see the potential benefit, I also find it confusing and annoying. Moreover, if you insert cells then hit F4 (redo) it will repeat the insert BUT it will also paste the copied cell if it is still active.
So, unless Microsoft adds a possibility to turn this off, we would have to watch for the "walking ants" and press Esc when we need to deactivate the copy mode.
