Forum Discussion

Richard Lukins's avatar
Richard Lukins
Copper Contributor
Dec 11, 2017

Paste using enter key no longer available

Hi I've used Excel for years and always used the Enter key for pasting data   Recently the enter key stopped performing the paste funtion on a couple of machines, just drops one line instead, s...
excel
Excel 2016
office365
Paste
Richard Lukins's avatar
Richard Lukins
Copper Contributor
Dec 11, 2017

Thanks, but other than the "Quick Repair Office" and "Online Repair Office (downloads new installer files)" both within the Change Office365 option of Control Panel > Programs and Features > Change

 

I've tried this on 2 machines that have the problem, neither has changed/returned to the original ability to use the <Enter> key to paste :-( ... including on the machine that worked first thing this morning but stopped working today.

 

I'm getting bald patches from pulling my hair out!

Thanks

Richard

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 11, 2017

Ask this https://answers.microsoft.com/en-us/.

It's more active than this, and has too many experts!

You may find someone who can help you!

  • Richard Lukins's avatar
    Richard Lukins
    Copper Contributor
    Dec 11, 2017

    thanks, will post there and hopefully someone will have found a solution!

    Thanks for your pointers

    Richard

    • Reyn Libunao's avatar
      Reyn Libunao
      Copper Contributor
      Feb 19, 2018
      Try this one.



      File > Options > Advanced

      Uncheck After pressing Enter, move selection
      • Richard Lukins's avatar
        Richard Lukins
        Copper Contributor
        Feb 19, 2018

        Hi and thanks for the suggestion, but right now the 2 machines I have in front of me are both operating again with normal <enter> key will paste, and that option is set to "move down"

         

        I tried a variety of key combinations like Alt + Ctrl and Enter, as read someone had success, and 2 out of 5 machines resumed operation, although I could not figure out which combo made it work or if it was due to an interim update via the Office 365 live updates. A wIn7 machine was still not operating last time I tried, about 6 weeks ago, but don't use that PC often, so had given up trying to fix it ...

         

        It is a strange behaviour to suddenly lose and randomly regain, with little chatter online about replication/removal other than a few specific issues, that are either patched or in version long since left behind ... but highly irritating after 30years to suddenly not be able to use one of the features/key combinations that is used most (by me)!!

         

        Would love to know if there is a key combo to toggle it, that I can use if it happens again, but I do think it was relating to updates, as the issue appeared on multiple machines at roughly the same time, and cleared at a similar time ... probably will never know!

         

        Thanks

        Richard

Resources