I paste a copied value and then want to insert cells, Excel will paste the insert into inserted cell
Ok, so I thought I was pretty good at Excel until I had this issue. I copy a cell and then paste. Then went to add a row. Well, I was surprised when the pasted value ending up in the whole row. I am using Office 365 and have searched for a solution, didn't find one. Went to Support and conntected with help who wanted me to repair online my version as Safe mode wouldn't work. Since it is not my office I had our company IT do this (repair was what they did). However, this was not the fix. It fixed the ability to open Excel in Safe mode, but not my clearing clipboard issue. So am stuck. I know on non-365 you could copy paste and then paste more if you chose to and then when you didn't want the clipboard you hit Delete and good to go, insert cells or rows with no dire consequences. Please help! Is there a way to clear the clipboard (outside of leaving the clipboard open and manually clearing it (which is ineffective and terrible for productivity)?
HELP: cell copied is deselected when clicking on formula bar.
MY PROBLEM The behaviour of excel seems different today, I can’t copy and paste a value directly on the formula bar any longer. When I copy a cell, it appears the usual dashed line to highlight that the cell is copied. As soon I click the Formula Bar, when any cell is selected, the dashed line disappears, and by clicking ctrl+V no value is pasted on the formula bar. I’m using Office 365, desktop version. HOW I TRIED TO SOLVE THE ISSUE I have just tried to restart the computer; I don’t know what else to try. WHAT I USED TO DO AND WHY When I need to copy a value (not formulas) from cell X to cell Y, I used to copy the cell X and paste the value directly on the formula bar of cell Y. I know that I could use Paste Special to paste only values, but the behaviour is different, and I prefer to copy directly on formula bar. For example, if in cell X the value is 1,000000005, and the cell is formatted to show only 2 decimals, I have two different value in cell Y if I paste to formula bar and or use Paste Special; if I copy and paste the value in cell Y with paste special, the value of cell Y is 1,000000005, and I need to format the cell to show only 2 decimals; on the contrary if I copy and paste on formula bar of cell Y, the pasted value is exactly 1,00, regardless of how I format cell Y. Sometimes I need the original value, sometimes I need the value already rounded; that’s why I don’t want to use paste special, but I would like to paste on formula bar. Moreover, by copying values on formula bar, instead of using paste special I also save a few clicks.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, so you have to use ctrl + V to paste, which i don't want ... (call me stuck in a rut or just too old to change!) Please note paste still works with all teh other methods, like Ctrl+V, right click and the edit menu etc, it's just the enter key that's stopped working for paste... On several other machines I can paste data using the enter key (all running office365 latest versions), so the feature has not been removed, it's just affecting 1 or 2 machines, so not a one off either! This morning on one machine which WAS still working for pasting with enter key, after quiting and restart excel 9not the PC, no updates or anything) it's stopped working, so now none of my own machines work! Enough is enough, I need a fix please! 2 of my machines the enter key stopped pasting a GOOD while ago, all have been running office365 (so excel 2016) for about 18-24months, all from the same family office account, all updated regularly, so currently on version 1711 build 8730.2122. one is Windows 7, rest are all Windows10 x64 I have checked the options and advanced features, but nothing there. I having searched google, found little relevant except a post, which suggested a "full repair online re-install" but this has not fixed the issue. Microsoft linked helpdesk (using the help chat option inside excel) got me nowhere, except a sore head :-( I don't have any clipboard managers enabled on all the machines in question, might have on one of them, and do use a KVM screen sharing tool called Multiplicity on them all, but this has not been updated recently, and did not affect the machine that continued to work using enter (until it stopped earlier today!), so can't see that being a factor? The feature was inbuilt into Excel, it was not an external macro or some VBA, although would consider using a fix using these if that was the only solution (if anyone has some code to share), but I'd much rather fix the issue via correct configuration, or registry key or whatever! Anyone able to help revert the enter key to provide paste capability? Thanks in advance Richard
