Excel Loses Reference to Data to Copy When I Type Elsewhere On the Sheet

Question

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?

Answer 1

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.

Answer 2

I know it is screen real estate, but I think you may want to use office clipboard - My google search on office clipboard.