ENTER key is no longer pasting content of clipboard

C

clautor

New Member
Joined
Jul 19, 2014
Messages
5
I used to be able to Ctrl+C and then hitting ENTER would paste the content into the new cell. It no longer happens since the latest Excel update. Has anybody had this happen and knows how to enable this feature again? I have done this for years and years and is making me waste a lot of time to not being able to do it anymore. Thank you for your time and help.

Claudia
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
clautor said:
I used to be able to Ctrl+C and then hitting ENTER would paste the content into the new cell. It no longer happens since the latest Excel update. Has anybody had this happen and knows how to enable this feature again? I have done this for years and years and is making me waste a lot of time to not being able to do it anymore. Thank you for your time and help.

Claudia
Click to expand...
Still works for me. What update are you referring to?
 
Upvote 0
Hi JLG. Thanks for your reply. Not sure. Just did the latest update to Office 365 and started doing this. I thought it was something Excel changed but based on the lack of information in internet, I'm thinking it is my computer instead. I'm going to do the good-old trick and reboot again and see if that solves the issue. Thanks for replying.
 
Upvote 0
clautor said:
Hi JLG. Thanks for your reply. Not sure. Just did the latest update to Office 365 and started doing this. I thought it was something Excel changed but based on the lack of information in internet, I'm thinking it is my computer instead. I'm going to do the good-old trick and reboot again and see if that solves the issue. Thanks for replying.
Click to expand...

It is possible that the feature was deleted in 365 version of Windows. I don't believe it was an Excel only feature because I just looked through the setting Options for Excel 2013 and it does not appear there. I didn't check in Control Panel because they have narrowed the options a user can change there to almost nothing, but that would be most likely where the option would be if it exists.
 
Upvote 0
Sorry, no immediate ideas about why it wouldn't be working.

But for what it's worth, CTRL-C and Enter still works fine for me in Office 365 ProPlus, fully updated Excel 2016.
 
Upvote 0
clautor, does it make any difference if you run this Sub:

Code: 
Sub TryThis()

    Application.OnKey "~"

End Sub

A bit of a long shot perhaps. Nothing to do with an Excel update, but just ruling out that the workbook you're using isn't running macro code from the Enter key.
 
Upvote 0
JLG: after repairing Excel and re-booting all is back to normal. Thanks again for taking the time to respond.
 
Upvote 0
Thanks Stephen. It seems to have been a temporary issue that presented after one Office update. Repairing Office and rebooting fixed the issue. Thanks for the suggestion though. =)
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Referencing tables in formula
2
Replies
13
Views
355
Peter_SSs
Peter_SSs
K
  • Question
Pause a macro when the user starts entering a number in the active cell & resume it when they hit the Enter key
Replies
3
Views
935
Jaafar Tribak
Jaafar Tribak
D
  • Solved
Fixed Position of Cursor Cell When Typing Enter/CTRL+Down Arrow
2
Replies
10
Views
1K
Peter_SSs
Peter_SSs
I
  • Solved
Using InStr to Find Matches Between Columns
Replies
1
Views
532
Farscape2020
F
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
384
AndyEd
A

Forum statistics

Threads
1,214,649
Messages
6,120,730
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top