I need to copy a row of 10 fields in excel. I can use Ctrl C for this.
When I paste the fields - I would like to only paste 1 field at a time into different fields in a different app.
Is it possible to copy the row fields once and when I paste into the other app - I can use Ctrl V but only paste the 1st field, so I can move to the 2nd field and paste the 2nd copied field from excel?
CodePudding user response：
Windows 10 and Windows 11 have a “Clipboard History” tool that allows the Clipboard to store multiple items that can be pasted at any time. If you copy each item you want to transfer individually, you can use this to approximate your desired functionality.
Microsoft turns this new “Clipboard History” feature off by default. Follow these steps to turn the “Clipboard History” feature on:
Open Settings.
Search for "Clipboard".
Select "Save Multiple Clipboard Items".
Toggle the “Clipboard history” setting to On.
The Clipboard History feature should now be active. Now, when you copy (or cut) items to the Clipboard all of those items will be stored (until restart) instead of being over-written when you copy or cut something new.
However, you can’t access the stored Clipboard items simply by clicking Paste or pressing Ctrl V. If you want to paste one of the previously stored items, press the Windows V key combination. Pressing Windows V will bring up the entire list of previously stored Clipboard items. Select one from this list to paste it in.
CodePudding user response：
As mentioned in the comment, this is impossible indeed: when you copy something to the clipboard, it is copied as one single instance. The Windows clipboard does not have the possibility to chop its contents into smaller pieces and deliver them one by one.
P.s. this does not only apply for Excel and/or VBA, but for every process, running on a Windows computer.