I've clearly hit some hotkey in Excel, and have odd copy/paste behaviour now.

The green dotted line that appears around cells when you ctrl-C them is now permanent. Normally it disappears once you paste somewhere, or if you move to another cell and edit it, or hit delete in an empty cell. Now the only way I can get rid of it is to hit escape.

What have I done, and how can I revert to the "normal" behaviour?


  • 1
    Does the issue persists if you restart your Excel/pc? – Máté Juhász Jun 24 '17 at 14:11
  • Yes it does, very persistent! – Codemonkey Jun 29 '17 at 9:13
  • See my answer below: – Codemonkey Jun 29 '17 at 9:30

This is intended behaviour and a (HUGELY FUNDAMENTAL) change that Microsoft have made to Excel:


"Keep the copy: Copy your cells and, before you paste, you can still do other tasks like typing or inserting cells."

I don't feel I was notified of this change (but maybe I was and dismissed/ignored it). Either way it certainly wasn't made abundantly clear to me. There should also be an opt-out for it, and doesn't appear to be.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.