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, in its infinite nanny-state wisdom, decides I no longer wish to paste any more copies of that common data, and 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. However, I'd rather Excel not screw me over just to save a few bytes on the clipboard in the first place. 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?