Paste All key is not working every time

%3CLINGO-SUB%20id%3D%22lingo-sub-1523710%22%20slang%3D%22en-US%22%3EPaste%20All%20key%20is%20not%20working%20every%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523710%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20are%206%20individual%20data%20in%20Excel%20Clipboard%20and%20when%20I%20hit%22paste%20all%22%2C%20the%20result%20is%20unpredictable%2C%26nbsp%3B%20sometimes%20all%20good%2C%20sometimes%20missing%20one%20or%20some%20of%20the%20data.%20the%20data%20is%20a%20small%20string%20of%2020%20letters%20or%20dates%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20paste%20all%20key%20is%20on%20clipboard%20panel%20on%20the%20left%20hand%20side%20of%20the%20PC%20screen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1523710%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524171%22%20slang%3D%22en-US%22%3EBetreff%3A%20Paste%20All%20key%20is%20not%20working%20every%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524171%22%20slang%3D%22en-US%22%3EMaybe%20this%20info%20will%20help%20you%20...%20if%20not%20please%20ignore%20it.%3CBR%20%2F%3E%3CBR%20%2F%3ETip%3A%20If%20you%20have%20copied%20a%2025th%20element%2C%20the%20first%20element%20will%20be%20removed%20from%20the%20clipboard.%3CBR%20%2F%3EExcel%20and%20the%20other%20Office%20programs%20have%20their%20own%20clipboard%20that%20can%20save%20up%20to%2024%20copies.%3CBR%20%2F%3E%3CBR%20%2F%3EDelete%20clipboard%20by%20command%3CBR%20%2F%3EPress%20the%20key%20combination%20%5BWindows%5D%20%2B%20%5BR%5D.%3CBR%20%2F%3EA%20small%20window%20now%20opens.%20Enter%20the%20following%20command%20there%3A%20(cmd%20%2F%20c%20%22echo%20off%20%7C%20clip%22)%2C%20copy%20content%20of%20().%20Click%20%22OK%22%20to%20confirm.%20The%20clipboard%20is%20then%20automatically%20emptied.%3CBR%20%2F%3E%3CBR%20%2F%3EAt%20the%20end%20of%20your%20action%2C%20you%20can%20also%20delete%20the%20data%20in%20your%20Excel%20clipboard%20either%20individually%20or%20together.%20To%20do%20this%2C%20either%20move%20the%20mouse%20pointer%20over%20the%20element%20to%20be%20deleted%20in%20the%20clipboard%2C%20click%20on%20the%20arrow%20and%20then%20on%20%22Delete%22%20or%20use%20the%20%22Delete%20all%22%20button.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530847%22%20slang%3D%22en-US%22%3EBetreff%3A%20Paste%20All%20key%20is%20not%20working%20every%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EHowever%2C%20the%20problem%20is%20not%20cleaning%20up%20the%20clipboard%20in%20Excel.%20My%20problem%20is%20when%20I%20click%20%22Paste%20All%22%20key%20on%20the%20Clipboard%20Pane%2C%20Excel%20behaves%20erratically%20that%20some%20time%20it%20works%20great%20to%20paste%20all%20data%20to%20a%20range%2C%20say%20B10%3A%20B15.%20The%20other%20instance%20some%20data%20are%20missing.%20%22Paste%20All%22%20key%20is%20not%20reliable.%20I%20am%20looking%20for%20any%20suggestion%20to%20improve%20the%20reliability%20of%20the%20key.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530996%22%20slang%3D%22en-US%22%3EBetreff%3A%20Paste%20All%20key%20is%20not%20working%20every%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530996%22%20slang%3D%22en-US%22%3EMaybe%20you%20can%20find%20some%20quick%20info%20here...otherwise%20i%20don't%20have%20a%20clou%20why%20excel%20clipboard%20behavior%20wrong.%20My%20small%20knowing%20is%20not%20enough%20to%20can%20help%20more.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Foffice%2Ftroubleshoot%2Fexcel%2Finsert-options-button%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Foffice%2Ftroubleshoot%2Fexcel%2Finsert-options-button%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWish%20you%20a%20good%20day%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3C%2FLINGO-BODY%3E
New Contributor

There are 6 individual data in Excel Clipboard and when I hit"paste all", the result is unpredictable,  sometimes all good, sometimes missing one or some of the data. the data is a small string of 20 letters or dates

 

The paste all key is on clipboard panel on the left hand side of the PC screen

3 Replies
Maybe this info will help you ... if not please ignore it.

Tip: If you have copied a 25th element, the first element will be removed from the clipboard.
Excel and the other Office programs have their own clipboard that can save up to 24 copies.

Delete clipboard by command
Press the key combination [Windows] + [R].
A small window now opens. Enter the following command there: (cmd / c "echo off | clip"), copy content of (). Click "OK" to confirm. The clipboard is then automatically emptied.

At the end of your action, you can also delete the data in your Excel clipboard either individually or together. To do this, either move the mouse pointer over the element to be deleted in the clipboard, click on the arrow and then on "Delete" or use the "Delete all" button.

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)

@Nikolino 

Thanks

However, the problem is not cleaning up the clipboard in Excel. My problem is when I click "Paste All" key on the Clipboard Pane, Excel behaves erratically that some time it works great to paste all data to a range, say B10: B15. The other instance some data are missing. "Paste All" key is not reliable. I am looking for any suggestion to improve the reliability of the key.

Maybe you can find some quick info here...otherwise i don't have a clou why excel clipboard behavior wrong. My small knowing is not enough to can help more.

https://docs.microsoft.com/en-gb/office/troubleshoot/excel/insert-options-button

Wish you a good day

Nikolino