Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 7 down vote accepted

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.

alt text

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.