+ Reply to Thread
Results 1 to 7 of 7

Excel 2016 - stop copying!!!!

  1. 03-08-2018, 01:47 PM #1
    heytherejem
    heytherejem is offline
    Forum Contributor heytherejem's Avatar
    Join Date
    07-06-2017
    Location
    Hampshire, England
    MS-Off Ver
    2016
    Posts
    152

    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
    Reply With QuoteRegister To Reply
  2. 03-08-2018, 01:56 PM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 03-08-2018, 01:57 PM #3
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Excel 2016 - stop copying!!!!

    After paste hit Escape
    Reply With QuoteRegister To Reply
  4. 03-08-2018, 02:06 PM #4
    MrShorty
    MrShorty is online now
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,821

    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.
    Reply With QuoteRegister To Reply
  5. 03-08-2018, 03:32 PM #5
    Zer0Cool
    Zer0Cool is offline
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    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
    Reply With QuoteRegister To Reply
  6. 03-09-2018, 05:26 AM #6
    heytherejem
    heytherejem is offline
    Forum Contributor heytherejem's Avatar
    Join Date
    07-06-2017
    Location
    Hampshire, England
    MS-Off Ver
    2016
    Posts
    152

    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!!!
    Reply With QuoteRegister To Reply
  7. 03-09-2018, 05:40 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Excel 2016 - stop copying!!!!

    LOL! Just keep escaping ...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. #N/A” Error Encountered When Copying Formulas in O365 Excel 2016
    By Tegglet in forum Office 365
    Replies: 4
    Last Post: 03-02-2018, 10:49 AM
  2. [SOLVED] No value given for one or more parameters - Access 2016 - Excel 2016
    By schulzy175 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2018, 10:11 PM
  3. 04-12-2016 date in excel changes to April 12th 2016 when in fact it should be Dec 4th 2016
    By raj4rev in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  5. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  6. How to stop "Security Warning Data Connections have been disabled" MAC OS Excel 2016
    By cmorten82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2017, 05:18 PM
  7. copying xls files to excel 2016
    By oskie89 in forum Excel General
    Replies: 2
    Last Post: 06-08-2017, 09:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1