OFFICE CLIPBOARD EXCEL UPDATE

To conclude that my problem was a design feature seems highly illogical.

I had to re-input the data in those lines without using copy and paste to be on the safe side. Used the selection and drag move on that file as I had checked all lines before doing the save and there were no blank lines at that time. With data as a result of selection and drag copy and found that a couple of lines had been blanked out because when the save on the file had been performed the selection and drag copies appear to have been replaced by selection and drag move. I reopened an Excel file that had some lines in it populated I additionally had a problem with using selection and drag copy which has put me off that facility. The warnings may not be a problem,Д«ut they are very off-putting when you are using Excel and lower your confidence in its stability. I have experienced these myself and they are well documented by others on the Microsoft forum. Additionally, you can get spurious clipboard errors and warnings when doing this. That wonвЂ™t fit in its entirety on the screen. This is more difficult, especially with a big spreadsheet

To get round the problem you can use selection and drag copy, selecting with the mouse and dragging to the required position while holding down the control key at the same time.

OFFICE CLIPBOARD EXCEL UPDATE

Given that the feature worked perfectly on my system in Excel 2016 under Windows 10 before the recent major update suggests strongly that the problem is a result of this update and not the The conclusion you have to come to is that the problem is either down to the Excel versionДў016 being different to version 2010 or the recent Windows 10 update. On a friendвЂ™s system which uses Excel 2016 (365 version) under Windows 10 with recent major update the feature doesnвЂ™t work. System worked perfectly on my clientвЂ™s system. Since the call to Microsoft I have tried the same operation on a clientвЂ™s system, which used Excel 2010 under Windows 10 which hadnвЂ™t had the recent major update yet, whereas my system had.In the end they concluded that my problem was a design feature, which I find a totally unsatisfactory resolution.

I know it isn't a fault with my computer, as I ran extensiveДiagnostics overnight with no faults being found. They looked at all the obvious things such as add-ins, but were unable to solve the problem. I contacted Microsoft for help and demonstrated the problem. When the paste is performed the blank cells are removed automatically by Excel and the cells with data in them moved so that they are next toД®ach other in the line starting from the left.

Following this update the facility no longer works when the line contains some blank cells.

However, about a month ago there was an automatic update to Windows 10, which judging by the time it took was Times, access those items to paste easily and paste them with the least effort wherever you are in the spreadsheet. Using the clipboard this way gives you a method to store several different lines or areas to be pasted, maybe multiple If you copy a complete line to the clipboard and wish to paste that complete line further down the spreadsheet you should be able to successfully do that pasteД«y clicking on the line to be pasted in the clipboard with your cursor at the start of the line where it is to be pasted in the spreadsheet. My problem is with using the clipboard in Excel to copy and paste complete lines on a spreadsheet.

I have noticed that other people seem to be having similar problems from what is on the forum, but don't believe there is an acceptable solution available at the Over the past month I have been experiencing problems with using the clipboard in Excel 2016.

Office clipboard excel