Moving dotted line not going away
Results 1 to 4 of 4

Thread: Moving dotted line not going away
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2016
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Moving dotted line not going away

    I couldn't seem to find another thread (or any mention of this elsewhere online) of this, so I apologize if this has been covered before.

    I have recently begun having an annoyance (I would say issue, but it doesn't really affect anything) using Excel. When you copy a cell or cells, there is a moving dotted line that runs around the outside of those copied cells. Typically, if you double-click a cell or cells away from this, that should go away. This is no longer the case for me. I can do any number of other operations, clicks, etc. Until I select and copy another cell or group of cells, that marquee keeps running around those cells I copied. It is quite annoying.

    Any thoughts on how to resolve this?

  2. #2
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,497
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Excel - Moving dotted line not going away

    Pressing the escape key will do it.

  3. #3
    New Member
    Join Date
    May 2016
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel - Moving dotted line not going away

    Thanks. Sorry for the delay on the thanks - for some reason, I never got the email notification that there was any reply to this.

  4. #4
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    872
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel - Moving dotted line not going away

    Let me provide some backstory on this. The behavior changed for Office 365 customers starting in June 2017. Acting in response to this request on Excel.UserVoice, the Excel team changed what events will cause the clipboard to be emptied.

    While this request seemed really innocuous, it has caused a lot of issues for people who routinely use Excel shortcuts. I still use the Excel 2003 Alt+I E to insert cells, but now the clipboard is hanging around longer and that same command does Insert Copied Cells. This is not an issue if you use the new style keyboard shortcuts: Alt, H, I, E or Alt, H, I, I. But for the old style shortcuts, it causes a problem.

    Thanks to Steve the Fish for the easy-to-remember Esc key to clear the clipboard. You can also take advantage of these:
    Ctrl+C to copy
    Ctrl+V to paste and keep the contents on the clipboard, or
    Enter to paste and clear the clipboard

    I am trying to train myself to use Enter when I don't need to do multiple pastes, but when I forget, pressing Esc will clear it.
    View a collection of recent Excel articles in the Excel Daily News

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •