That's the way excel works.

Maybe you could change the order you do things--paste into B, C, etc, then fill
down.

bertremCA wrote:

Consider the following sequence of operations:
1. copy cell A
2. paste to cell B
3. block select from B down a few cells
4. ^D to fill down
5. paste to cell C yields nothing because the copy buffer was seemingly
obliterated by #4.

This is very friustrating behavior and seemingly inconsistent with what one
would expect based on the behavior of almost every other application, many of
which even leave their contents on the clipboard after exiting.

using Excel 2003 (11.6560.6568) SP2

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson