I'm making a list in Excel where many rows have the same data in a number of columns, enough so that I'd like to hit Ctrl-C once on this set of common data, and then just hit Ctrl-V every time I make a new row that has those attributes.
The problem is, after I paste one time using Ctrl-V, and then go to type in the header for the next row, Excel, removes that information from the clipboard, so if I want to copy it again, I have to select it and hit Ctrl-C again.
I can work around this by pasting the data into Notepad as a tabbed list, then copy from Notepad using Ctrl-C. This way, the clipboard is managed by Windows, not hijacked by Excel.
Is there an option or some other way to copy/paste so that Excel won't empty the clipboard contents even if I type between pastes?
Answer
You can use the "Office Clipboard" manager to hold copied data for a longer period of time. Click the button in the lower-right of the Clipboard group to pull it up.
Whenever you copy data, it will be dumped into the manager. To paste the item, click on it. Subsequent Ctrl-V pastes will paste from the highlighted option in the clipboard.
No comments:
Post a Comment