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)?