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?