+ Reply to Thread
Results 1 to 7 of 7

Excel 2016 - stop copying!!!!

  1. #1
    Forum Contributor heytherejem's Avatar
    Join Date
    07-06-2017
    Location
    Hampshire, England
    MS-Off Ver
    2016
    Posts
    124

    Excel 2016 - stop copying!!!!

    Hi there,

    I've recently upgraded to Office 2016 at work and one thing I can't figure out is that when I copy and paste a cell or range in Excel, it maintains the copy for all of eternity, until I copy something else. So there is always a moving dotted line somewhere on my spreadsheet. It is infuriating.
    And when I want to insert a row or similar, the first option is "Insert Copied Cells" which I copied about 4 hours ago.

    Does anyone know how to disable this wretched functionality? I have Googled it to no avail, and i'm on the verge of mass hysteria.

    Thanks in advance (please save me)

    Jemma

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,243

    Re: Excel 2016 - stop copying!!!!

    I'm not sure that one person alone can have mass hysteria, but I do feel your pain.

    It takes a bit of getting used to, but can prove quite handy. A quick click of the ESC key will rid you of the marching ants.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    Re: Excel 2016 - stop copying!!!!

    After paste hit Escape
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    9,831

    Re: Excel 2016 - stop copying!!!!

    As one who uses the keyboard to navigate more than the mouse, I typically copy paste by
    1) Select source cells
    2) ctrl-C to copy to clipboard
    3) select destination
    4a) Enter key to paste in destination and clear clipboard
    4b) ctrl-V to paste and keep source in clipboard. (repeat 4b for each desired destination, then Esc to clear clipboard).

    I have occasionally wished there was a menu/ribbon equivalent for the Enter key (step 4a) "paste and clear clipboard" command, but I don't use the ribbon/menus for copying and pasting enough to become hysterical about it .
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Valued Forum Contributor
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,190

    Re: Excel 2016 - stop copying!!!!

    The "marching ants" remain until you either act upon another part of Excel (entering data, another copy/paste, creating new sheet, etc). You can deselect the source range using esc manually.

    The benefit of it staying is to represent visually what was last copied to the clipboard. Other then the animation being present it shouldn't hinder you in any way.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

  6. #6
    Forum Contributor heytherejem's Avatar
    Join Date
    07-06-2017
    Location
    Hampshire, England
    MS-Off Ver
    2016
    Posts
    124

    Re: Excel 2016 - stop copying!!!!

    Thanks to everyone who responded, looks like i'll be using my escape key a lot more now!
    It hadn't occurred to me to try that - I had tried ctrl D with no success.

    I think I could definitely have a good go at inciting mass hysteria on my own - I'm not sure people would buy into the 'excel won't stop copying the last cell' fiasco so it is left to me to carry the hysterical baton!!!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,243

    Re: Excel 2016 - stop copying!!!!

    LOL! Just keep escaping ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1